【文章內(nèi)容簡介】 points hcpe, hz_parties hp, hz_cust_accounts hca WHERE = AND = AND = (+) AND (+) = AND (+) = AND (+) = AND = 39。PERSON39。 AND (+) = 39。CONTACT39。 AND (+) = 39。HZ_PARTIES39。 AND (+) = 39。HZ_PARTIES39。 AND (+) = 39。HZ_PARTIES39。 AND (+) = 39。PHONE39。 AND (+) = 39。GEN39。 AND (+) = 39。PHONE39。 AND (+) = 39。MOBILE39。 AND (+) = 39。EMAIL39。 AND IS NULL AND = AND = ORDER BY ?？蛻糍~戶地點地址SELECT , , , , , , , , , , FROM hz_parties hp, hz_cust_accounts hca, hz_party_sites hps, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua WHERE = AND = AND = AND = 客戶主配置文件SELECT * FROM hz_cust_profile_classes。SELECT * FROM hz_customer_profiles。SELECT * FROM hz_cust_prof_class_amts。SELECT * FROM hz_cust_profile_amts。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ā)運(yùn)數(shù)量, 計劃發(fā)運(yùn)日期, 登記標(biāo)記, 工作流狀態(tài), 取消標(biāo)記 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。CLOSED39。, 39。CANCELLED39。) and = and = 141 and = and = 39。LINE_FLOW_STATUS39。 AND IN (39。9101007239。, 39。9101006739。, 39。9101003639。) order by party_name，收貨地，銷售訂單。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。1414000278139。 內(nèi)部申請 =14140002781 申請單頭ID = 3379 申請單行明細(xì) 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 申請單頭ID, , OU_ID, 申請單編號, 創(chuàng)建日期, 編制人ID, 用戶名稱, 用戶姓名, 批準(zhǔn)日期, 說明, 狀態(tài), 類型, 傳遞標(biāo)示, 對方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。1414000278139。(銷售訂單記錄有對方 OU_ID,申請單關(guān)鍵字SOURCE_DOCUMENT_ID 申請單號SOURCE_DOCEMENT_REF)*******************綜合查詢類*******************申請單頭綜合查詢 （進(jìn)限制只能查詢 電網(wǎng)組織ORG_ID=112)SELECT 申請單頭ID, 組織ID, 申請單編號, 創(chuàng)建日期, 編制人ID, 用戶名稱, 用戶姓名, 批準(zhǔn)日期, 說明, 狀態(tài), 類型, 傳遞標(biāo)示, 行ID, 行號, 分類ID, 物料ID, 物料編碼, 物料說明, 需求數(shù), 送貨數(shù), 取消數(shù), 單位, 參考價, 需求日期, 來源類型, 對方組織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。若需創(chuàng)建視圖只需在 SELECT 語句前加上 CREATE OR REPLACE VIEW CUX_INV_PR112 AS7. 采購訂單PO采購單頭信息 TYPE_LOOKUP_CODE=39。STANDARD39。 （以供應(yīng)處OU ORG_ID=119 采購單=39。39。 為例）類型說明 TYPE_LOOKUP_CODE=39。STANDARD39。為采購單 TYPE_LOOKUP_CODE=39。BLANKET39。為采購協(xié)議SELECT OU_ID, 采購單頭ID, 類型, 狀態(tài), 供應(yīng)商ID, 供應(yīng)商名, 供應(yīng)商地址ID, 供應(yīng)商聯(lián)系人ID, 本方收貨地ID, 本方收單地ID, 創(chuàng)建日期, 審批YN, 審批日期, 采購單說明, 條款I(lǐng)D, 采購員ID, 采購員, 創(chuàng)建者ID, 創(chuàng)建用戶, 用戶姓名 FROM PO_HEADERS_ALL POH, FND_USER FU, per_people_f PP,PER_ALL_PEOPLE_F AGT_PP,ap_suppliers VENDOR WHERE = AND = AND = AND = AND = 119 AND = 39。STANDARD39。 AND = 39。1473000543639。 /* FND_USER FU, per_people_f PP 用戶相關(guān)表 po_agents_name_v 采購員視圖 = 采購員相關(guān)表 ap_suppliers 供應(yīng)商主表 */ =