【正文】 _PARTY_ID, END_DATE FROM FND_USER。%供應(yīng)處%39。 WHEN 39。 THEN 39。) 39。 39。PHONE39。GEN39?？蛻舻攸c業(yè)務(wù)目的 (關(guān)聯(lián)hz_cust_acct_sites_all 用CUST_ACCT_SITE_ID)SELECT * FROM HZ_CUST_SITE_USES_ALL。39。 AND (+) = 39。 AND IS NULL AND = AND IS NULL ORDER BY 。 AND (+) = 39。CLOSED39。1414000278139。 PO_HEADER_ID = 10068采購單行信息SELECT OU_ID, 采購單頭ID, 行ID, 行號, 物料ID, 物料編碼, 物料說明, 單位, 單價, 訂購數(shù), 驗收數(shù), 接收數(shù), 拒絕數(shù), 取消數(shù), 到票數(shù), 承諾日期, 需求日期 FROM PO_LINES_ALL POL, Po_Line_Locations_all PO_LCT, MTL_SYSTEM_ITEMS ITEM WHERE = AND = AND = AND = 142 AND = 119 AND = 10068。1802020001239。 select inventory_item_id, organization_id, item_cost, program_update_date from cst_item_cost_details where inventory_item_id = 23760 and organization_id = 142。XJ3956239。離散作業(yè)任務(wù)子查詢———工單工序狀況查詢（不單獨使用）select , , COUNT(1) COUNT_OPER, max(decode(, 1, , 10)) OPER from WIP_DISCRETE_JOBS WDJ, WIP_OPERATIONS WO where 1 = 1 AND = AND = 39。)SELECT 清單序號, 裝配件內(nèi)碼, 物料編碼, 物料說明, 組織內(nèi)碼, 操作ID, 物料序號, 工序, 子物料內(nèi)碼, 物料編碼, 物料說明, 構(gòu)件數(shù)量, 子計量單位碼, 子計量單位名, 供應(yīng)子倉庫 FROM (select BID, F_ITEMID, OGT_ID, CID, ITEM_NUM, OPID, C_ITEMID, QTY, WHSE from bom_inventory_ponents AA, bom_bill_of_materials BB where = ) VBOM, mtl_system_items BB, mtl_system_items CC WHERE = and = and = and = and = 142 and = 39。4712123139。 AND = 39。6. 采購申請PR申請單頭 （以電網(wǎng)組織ORG_ID=112 內(nèi)部申請 =14140002781 為例SELECT 申請單頭ID, , OU_ID, 申請單編號, 創(chuàng)建日期, 編制人ID, 用戶名稱, 用戶姓名, 批準(zhǔn)日期, 說明, 狀態(tài), 類型, 傳遞標(biāo)示 FROM PO_REQUISITION_HEADERS_ALL PRH, FND_USER FU, per_people_f PP WHERE = AND = AND = 112 AND = 39。SELECT * FROM hz_customer_profiles。 AND (+) = 39。 AND (+) = 39。 || contact_person, phone_area_code, phone_number, phone_extension, mobile_phone_area_code, mobile_phone_number, _address FROM hz_relationships hr, hz_cust_account_roles hcar, hz_org_contacts hoc, hz_contact_points hcpp, hz_contact_points hcpm, hz_contact_points hcpe, hz_parties hp, hz_cust_accounts hca WHERE = AND = AND = (+) AND (+) = AND (+) = AND (+) = AND = 39。39。客戶名稱及地址全局信息表 PARTY_NUMBER = 19316SELECT * FROM hz_parties AA WHERE = 21302。HZ_PARTY_SITES39。PHONE39。) AND = (+)供應(yīng)商銀行信息SELECT vendor_id, party_id, bank_id, bank_name, branch_id, bank_branch_name, bank_account_num FROM ap_suppliers ass, hz_parties hp, iby_account_owners iao, iby_ext_bank_accounts ieba, hz_parties bank, hz_parties branch WHERE = AND = (+) AND = (+) AND = (+) AND = (+) ORDER BY 。 THEN 39。 WHEN TO_CHAR(, 39。) 性別, decode 適合和同一值做比較有多種結(jié)果，不適合和多種值比較有多種結(jié)果 CASE WHEN 39。用戶責(zé)任關(guān)系SELECT USER_ID, RESPONSIBILITY_ID FROM FND_USER_RESP_GROUPS。 ORDER BY USER_NAME。F39。60年代39。200039。 || 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。客戶地點詳細(xì)信息表，以供應(yīng)處OU的身份 ORG_ID = 119SELECT 客戶組織地點ID, 客戶組織ID, 地點ID, 地點編號, 地址標(biāo)示, 有效否, , 業(yè)務(wù)實體, 收單標(biāo)示, 收貨標(biāo)示, 地點名稱, , , , , 業(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。 || || 39。HZ_PARTIES39?？蛻舻刂稴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,