【正文】 ND = AND = AND = 獲取系統(tǒng)IDcall (1318,50583,401)select (39。用戶表SELECT USER_ID, USER_NAME, EMPLOYEE_ID, PERSON_PARTY_ID, END_DATE FROM FND_USER。 ORDER BY USER_NAME。男39。女39。M39。F39。NULL39。196039。YYYY39。60年代39。198039。YYYY39。80年代39。200039。21世紀(jì)39。LANG39。供應(yīng)商開戶行地址信息SELECT party_id, party_site_id, location_id, country, province, city, address1, address2, address3, address4 FROM hz_party_sites hps, hz_locations hl WHERE = ORDER BY 供應(yīng)商聯(lián)系人信息SELECT subject_id, object_id, party_id, || 39。 || contact_person, phone_area_code, phone_number, phone_extension, fax_phone_area_code, fax_phone_number, _address FROM hz_relationships hr, hz_contact_points hcpp, hz_contact_points hcpf, hz_contact_points hcpe, hz_parties hp WHERE = AND (+) = AND (+) = AND (+) = AND = 39。 AND (+) = 39。 AND (+) = 39。 AND (+) = 39。 AND (+) = 39。 AND IS NULL ORDER BY 。 AND (+) = 39。 AND (+) = 39。 AND (+) = 39。 AND (+) = 39。供應(yīng)商銀行帳戶分配層次關(guān)系SELECT * FROM iby_pmt_instr_uses_all?？蛻舻攸c(diǎn)賬戶主文件SELECT * FROM hz_cust_acct_sites_all WHERE CUST_ACCOUNT_ID = 1063?？蛻舻攸c(diǎn)詳細(xì)信息表，以供應(yīng)處OU的身份 ORG_ID = 119SELECT 客戶組織地點(diǎn)ID, 客戶組織ID, 地點(diǎn)ID, 地點(diǎn)編號(hào), 地址標(biāo)示, 有效否, , 業(yè)務(wù)實(shí)體, 收單標(biāo)示, 收貨標(biāo)示, 地點(diǎn)名稱, , , , , 業(yè)務(wù)目的, 收單地ID, FROM hz_party_sites AA, hz_cust_acct_sites_all BB, hz_locations CC, HZ_CUST_SITE_USES_ALL DD WHERE = AND = 1063 AND = 119 AND = 39。 *************綜合查詢************客戶主數(shù)據(jù)SELECT customer_id, customer_number, customer_name, customer_short_name, customer_type, customer_type_meaning, customer_class, customer_class_meaning, tax_registered_name, term_name, creation_date, created_by, last_update_date, last_updated_by, last_update_login FROM hz_parties hp, hz_cust_accounts hca, ar_lookups alt, ar_lookups alc, hz_customer_profiles hcp, ra_terms rt WHERE = AND = (+) AND = 39。 AND = (+) AND = (+)客戶收款方法SQLSELECT receipt_method_nameFROM hz_cust_accounts hca, ra_cust_receipt_methods rcrm, ar_receipt_methods armWHERE = AND = ORDER BY 。 || || 39。 || || 39。 || || 39。 39。PERSON39。HZ_PARTIES39。HZ_PARTIES39。GEN39。MOBILE39?？蛻舻刂稴ELECT customer_site_id, customer_id, customer_site_code, customer_site_name, address_line1, address_line2, address_line3, address_line4, org_id, country, province, city, county, zip, bill_to_flag, ship_to_flag, creation_date, created_by, last_update_date, last_updated_by, last_update_login FROM hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_party_sites hps, hz_locations hl WHERE = AND = AND = 。 39。CONTACT39。HZ_PARTIES39。PHONE39。PHONE39。EMAIL39。SELECT * FROM hz_cust_prof_class_amts。, 39。 AND IN (39。, 39。1414000278139。(銷售訂單記錄有對(duì)方 OU_ID,申請(qǐng)單關(guān)鍵字SOURCE_DOCUMENT_ID 申請(qǐng)單號(hào)SOURCE_DOCEMENT_REF)*******************綜合查詢類*******************申請(qǐng)單頭綜合查詢 （進(jìn)限制只能查詢 電網(wǎng)組織ORG_ID=112)SELECT 申請(qǐng)單頭ID, 組織ID, 申請(qǐng)單編號(hào), 創(chuàng)建日期, 編制人ID, 用戶名稱, 用戶姓名, 批準(zhǔn)日期, 說明, 狀態(tài), 類型, 傳遞標(biāo)示, 行ID, 行號(hào), 分類ID, 物料ID, 物料編碼, 物料說明, 需求數(shù), 送貨數(shù), 取消數(shù), 單位, 參考價(jià), 需求日期, 來源類型, 對(duì)方組織ID, 本方組織ID FROM PO_REQUISITION_HEADERS_ALL PRH, FND_USER FU, per_people_f PP, PO_REQUISITION_LINES_ALL PRL, MTL_SYSTEM_ITEMS ITEM WHERE = AND = AND = AND = AND = AND = AND = 112。39。BLANKET39。1473000543639。說明：Po_Line_Locations_all 系“發(fā)運(yùn)表”綜合查詢1，所分配給供應(yīng)處組織的物料，存在采購協(xié)議，但缺失采購員或缺失倉庫；select 物料編碼, 物料描述, 物料詳細(xì)描述, 計(jì)量單位, 采購員, 默認(rèn)接收庫存, 未稅價(jià), round( * (1 + / 100), 2) 含稅價(jià), 供應(yīng)商名稱 from PHA, PLA, MSIF, MISD, PRF, PV, PVSA, ZRB where = 39。 and in (39。) and NVL(, sysdate) = sysdate and NVL(, sysdate) = sysdate and = 39。, 39。物料庫存數(shù)量SELECT , , , SUM() QTY FROM mtl_onhand_quantities MOQ WHERE = 12781 AND = 1155 GROUP BY , , 。子庫存列表SELECT * FROM mtl_secondary_inventorie