【正文】 group by ,。 ORDER BY 。YYYYMMDD39。 /* FND_USER FU, per_people_f PP 用戶相關表 po_agents_name_v 采購員視圖 = 采購員相關表 ap_suppliers 供應商主表 */ = 39。 內部申請 =14140002781 申請單頭ID = 3379 申請單行明細 SELECT 申請單ID, 行ID, 行號, 分類ID, 物料ID, 物料編碼, 物料說明, 需求數(shù), 送貨數(shù), 取消數(shù), 單位, 參考價, 需求日期, 來源類型, OU_ID, 對方組織ID, 本方組織ID from PO_REQUISITION_LINES_ALL PRL,MTL_SYSTEM_ITEMS ITEM WHERE = 112 AND = AND = AND = 3379。SELECT * FROM hz_cust_profile_amts。 AND (+) = 39。 AND (+) = 39。 AND (+) = 39。39。客戶地點 (關聯(lián)hz_cust_acct_sites_all)SELECT * FROM HZ_PARTY_SITES WHERE PARTY_ID = 21302。PHONE39。GEN39。 39。 WHEN TO_CHAR(, 39。) 39。 THEN 39。人員表VIEWSELECT PERSON_ID, START_DATE, DATE_OF_BIRTH, EMPLOYEE_NUMBER, NATIONAL_IDENTIFIER, SEX, FULL_NAME FROM per_people_f。綜合查詢SELECT USER_NAME, FULL_NAME, RESPONSIBILITY_NAME, FROM FND_USER AA, FND_USER_RESP_GROUPS BB, FND_RESPONSIBILITY_VL CC, per_people_f DD WHERE = AND = AND = AND RESPONSIBILITY_NAME like 39。男39。197039。YYYY39。 || || 39。 AND (+) = 39。 AND (+) = 39。地點地址名稱 (關聯(lián)hz_cust_acct_sites_all)SELECT , FROM HZ_LOCATIONS AA, HZ_PARTY_SITES BB WHERE = AND = 21302。 || || 39。CONTACT39。EMAIL39。HZ_PARTIES39。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未結銷售訂單SELECT 銷售訂單, 客戶PO, 客戶編碼, 客戶名稱, 收貨地, 收單地, 訂單日期, 合同號, 屏號, 來源編碼, 行號, 物料, 物料說明, 訂購單位, 訂購數(shù)量, 取消數(shù)量, 發(fā)運數(shù)量, 計劃發(fā)運日期, 登記標記, 工作流狀態(tài), 取消標記 FROM OE_ORDER_HEADERS_ALL H, OE_ORDER_LINES_ALL L, HZ_CUST_ACCOUNTS CUST, hz_parties hp, hz_cust_site_uses_all ship_use, hz_cust_site_uses_all bill_use, mtl_system_items_b msi, oe_lookups ol WHERE 1 = 1 AND = AND = and = and = and = and not in (39。申請單頭 (加對方訂單編號)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。1473000543639。) and = and = and = and ( is null or is null)采購其他相關表select * from po_distributions_all 分配select * from po_releases_all select * from rcv_shipment_headers 采購接收頭select * from rcv_shipment_lines 采購接收行select * from rcv_transactions 接收事務處理select * from po_agentsselect * from po_vendors select * from po_vendor_sites_all8. 庫存INV物料主表select 組織ID, 物料ID, 物料編碼, 物料說明, 項目類型, 制造或購買, 基本度量單位, BOM標志, 庫存資產否, 采購員ID, 可采購否, 采購項目, 單位, 是否為庫存, 是否批量, 是否要預留, 能否庫存, 固定提前期, 固定批量大小, 庫存計劃方法, 最大定單數(shù), 最小定單數(shù), 固定提前期, 計劃員碼, 接收子倉庫, 來源子倉庫, 供應子倉庫, 老編碼, 物料狀態(tài), 安全庫存量 from mtl_system_items MSI, MTL_ITEM_SUB_DEFAULTS MISD,mtl_safety_stocks MSS where = (+) and = (+) and = (+) and = (+) and = 1155 and = 39。單層BOM成本查詢(需系統(tǒng)提交請求計算后)select inventory_item_id, organization_id, item_cost, program_update_date from where inventory_item_id = 23760 and organization_id = 142。離散作業(yè)任務BOM (無材料費)SELECT 組織ID, 任務令ID, 裝配件名稱, 裝配件ID, 裝配件物料編碼, 裝配件說明, 工序號, 部門ID, 供應類型, 要求日期, 子物料ID, 子物料編碼, 子物料說明, 單位需量, 總需求量, 已發(fā)放量, 注釋, 供應子庫 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。4882539。5XJ06198839。, 39。1473000543639。1414000278139。SELECT * FROM hz_cust_prof_class_amts。HZ_PARTIES39。MOBILE39。PERSON39。 || || 39?？蛻舻攸c賬戶主文件SELECT * FROM hz_cust_acct_sites_all WHERE CUST_ACCOUNT_ID = 1063。 AND (+) = 39。 AND (+) = 39。供應商開戶行地址信息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 供應商聯(lián)系人信息SELECT subject_id, object_id, party_id, || 39。80年代39。YYYY39。M39。用戶表SELECT USER_ID, USER_NAME, EMPLOYEE_ID, PERSON