【正文】 系人、電話、手機和Email SQLSELECT party_id, cust_account_id, cust_acct_site_id, || 39。39。CUSTOMER CLASS39?？蛻舻攸c業(yè)務(wù)目的 (關(guān)聯(lián)hz_cust_acct_sites_all 用CUST_ACCT_SITE_ID)SELECT * FROM HZ_CUST_SITE_USES_ALL。供應(yīng)商地址收件人信息SELECT FROM ap_supplier_sites_all assa根據(jù)party_site_id得到供應(yīng)商地址的收件人名稱 SELECT FROM hz_party_sites hps。GEN39。HZ_PARTY_SITES39。PHONE39。HZ_PARTIES39。 39。 AND (+) = userenv(39。) 39。 WHEN TO_CHAR(, 39。 THEN 39。) 39。 WHEN 39。,39。%供應(yīng)處%39。OPERATING_UNIT39。用戶表SELECT USER_ID, USER_NAME, EMPLOYEE_ID, PERSON_PARTY_ID, END_DATE FROM FND_USER。男39。M39。NULL39。YYYY39。198039。80年代39。21世紀39。供應(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。 AND (+) = 39。 AND (+) = 39。 AND IS NULL ORDER BY 。 AND (+) = 39。 AND (+) = 39?？蛻舻攸c賬戶主文件SELECT * FROM hz_cust_acct_sites_all WHERE CUST_ACCOUNT_ID = 1063。 *************綜合查詢************客戶主數(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。 || || 39。 || || 39。PERSON39。HZ_PARTIES39。MOBILE39。 39。HZ_PARTIES39。PHONE39。SELECT * FROM hz_cust_prof_class_amts。 AND IN (39。1414000278139。39。1473000543639。 and in (39。, 39。子庫存列表SELECT * FROM mtl_secondary_inventories。5XJ06198839。39。4882539。 離散作業(yè)任務(wù)子查詢0201———作業(yè)資源報工明細表SELECT 組織代碼, 交易代碼, 參考科目, 報工日期, 任務(wù)令內(nèi)碼, 會計欄類型, 費用額, 反方集代碼, 基本數(shù)量, 率或金額,。離散作業(yè)任務(wù)BOM (無材料費)SELECT 組織ID, 任務(wù)令I(lǐng)D, 裝配件名稱, 裝配件ID, 裝配件物料編碼, 裝配件說明, 工序號, 部門ID, 供應(yīng)類型, 要求日期, 子物料ID, 子物料編碼, 子物料說明, 單位需量, 總需求量, 已發(fā)放量, 注釋, 供應(yīng)子庫 FROM wip_requirement_operations WOP, wip_entities BB, mtl_system_items CC, mtl_system_items DD WHERE = and = and = and = and = and = 1155 and = 39。XJ3956239。單層BOM成本查詢(需系統(tǒng)提交請求計算后)select inventory_item_id, organization_id, item_cost, program_update_date from where inventory_item_id = 23760 and organization_id = 142。計劃員表 SELECT PLANNER_CODE 計劃員代碼, ORGANIZATION_ID 組織代碼, DESCRIPTION 計劃員描述, 員工ID, DISABLE_DATE 失效日期 FROM mtl_planners MP。) and = and = and = and ( is null or is null)采購其他相關(guān)表select * from po_distributions_all 分配select * from po_releases_all select * from rcv_shipment_headers 采購接收頭select * from rcv_shipment_lines 采購接收行select * from rcv_transactions 接收事務(wù)處理select * from po_agentsselect * from po_vendors select * from po_vendor_sites_all8. 庫存INV物料主表select 組織ID, 物料ID, 物料編碼, 物料說明, 項目類型, 制造或購買, 基本度量單位, BOM標志, 庫存資產(chǎn)否, 采購員ID, 可采購否, 采購項目, 單位, 是否為庫存, 是否批量, 是否要預留, 能否庫存, 固定提前期, 固定批量大小, 庫存計劃方法, 最大定單數(shù), 最小定單數(shù), 固定提前期, 計劃員碼, 接收子倉庫, 來源子倉庫, 供應(yīng)子倉庫, 老編碼, 物料狀態(tài), 安全庫存量 from mtl_system_items MSI, MTL_ITEM_SUB_DEFAULTS MISD,mtl_safety_stocks MSS where = (+) and = (+) and = (+) and = (+) and = 1155 and = 39。, 39。1473000543639。STANDARD39。申請單頭 (加對方訂單編號)SELECT 申請單頭ID, , OU_ID, 申請單編號, 創(chuàng)建日期, 編制人ID, 用戶名稱, 用戶姓名, 批準日期, 說明, 狀態(tài), 類型, 傳遞標示, 對方CO編號 FROM PO_REQUISITION_HEADERS_ALL PRH, FND_USER FU, per_people_f PP,OE_ORDER_HEADERS_ALL OEH WHERE = AND = AND = (+) AND = 112 AND = 39。, 39。5. 訂單OEselect * from oe_order_headers_all 銷售頭select * from oe_order_lines_all 銷售行select * from wsh_new_deliveries 發(fā)送select * from wsh_delivery_detailsselect * from wsh_delivery_assignments綜合查詢1未結(jié)銷售訂單SELECT 銷售訂單, 客戶PO, 客戶編碼, 客戶名稱, 收貨地, 收單地, 訂單日期, 合同號, 屏號, 來源編碼, 行號, 物料, 物料說明, 訂購單位, 訂購數(shù)量, 取消數(shù)量, 發(fā)運數(shù)量, 計劃發(fā)運日期, 登記標記, 工作流狀態(tài), 取消標記 FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL L, HZ_CUST_ACCOUN