【正文】 s。BOM明細(xì)表bom_inventory_ponentsselect BILL_SEQUENCE_ID 清單序號, COMPONENT_SEQUENCE_ID 構(gòu)件序號, ITEM_NUM 項目序列, OPERATION_SEQ_NUM 操作序列號, COMPONENT_ITEM_ID 子物料內(nèi)碼, COMPONENT_QUANTITY 構(gòu)件數(shù)量, DISABLE_DATE 失效日期, supply_subinventory 供應(yīng)子庫存, BOM_ITEM_TYPE from bom_inventory_ponents。5XJ06198839。10. 作業(yè)任務(wù)WIP 說明： 查詢作業(yè)任務(wù)頭以及作業(yè)任務(wù)工序和BOM情況作業(yè)任務(wù)頭信息表（以直流 OU_ID=117；ORGANIZATION_ID=1155。39。XJ3956239。4882539。 作業(yè)任務(wù)已發(fā)放材料處理記錄清單0101（最詳細(xì)） （內(nèi)碼為48825為例）用途 1）查詢工單發(fā)料詳細(xì)明細(xì)，包括發(fā)料類型、時間、用戶等select 交易ID, 項目ID, 物料編碼, 物料說明, 組織ID, 子庫名稱, 交易類型ID, 交易類型名稱, 交易數(shù)量, 單位, 交易日期, 交易參考, 參考源ID, 任務(wù)名稱, 部門ID, 工序號, ROUND(, 2) 原來成本, ROUND(, 2) 新成本, * ROUND(, 2) 交易金額, 用戶名稱, 用戶姓名 from mtl_material_transactions MTL, mtl_transaction_types BB, mtl_system_items CC, FND_USER DD, per_people_f EE, wip_entities FF where = and = and = and = and = and = and in (35, 38, 43, 48) and = 1155 and = 48825。 離散作業(yè)任務(wù)子查詢0201———作業(yè)資源報工明細(xì)表SELECT 組織代碼, 交易代碼, 參考科目, 報工日期, 任務(wù)令內(nèi)碼, 會計欄類型, 費(fèi)用額, 反方集代碼, 基本數(shù)量, 率或金額,。 離散作業(yè)任務(wù)子查詢01———材料消耗狀況及材料費(fèi)綜合查詢 用途 1）查詢發(fā)料狀況 2）查詢材料費(fèi)物料小計SELECT 組織ID, 任務(wù)令I(lǐng)D, 裝配件名稱, 裝配件ID, 裝配件物料編碼, 裝配件說明, 工序號, 部門ID, 供應(yīng)類型, 要求日期, 子物料ID, 子物料編碼, 子物料說明, 單位需量, 總需求量, 已發(fā)放量, 已發(fā)生材料費(fèi), 注釋, 供應(yīng)子庫 FROM wip_requirement_operations WOP, wip_entities BB, mtl_system_items CC, mtl_system_items DD, (select orgID, wipID, oprID, itemID, sum( * ROUND(, 2)) amt from mtl_material_transactions MTL where in (35, 38, 43, 48) and = 1155 and = 48825 group by , , , ) CST WHERE = and = and = and = and = and = and = and = and = and = 1155 and = 39。離散作業(yè)任務(wù)BOM (無材料費(fèi))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。XJ3956239。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。5XJ06198839。計劃員表 SELECT PLANNER_CODE 計劃員代碼, ORGANIZATION_ID 組織代碼, DESCRIPTION 計劃員描述, 員工ID, DISABLE_DATE 失效日期 FROM mtl_planners MP。 綜合查詢庫存數(shù)量及成本SELECT 組織ID, 物料ID, 物料編碼, 物料說明, M1P2, 子庫存, 當(dāng)前庫存量, 單位成本, 材料成本, 間接費(fèi), 人工費(fèi), 外協(xié)費(fèi), 制造費(fèi) FROM MTL_SYSTEM_ITEMS MSI, CST_ITEM_COSTS CST, (SELECT , , , SUM() QTY FROM mtl_onhand_quantities MOQ WHERE = 1155 GROUP BY , , ) MOQV WHERE = (+) AND = (+) AND = (+) AND = (+) AND = 2 AND = 1155 AND = 39。) 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標(biāo)志, 庫存資產(chǎn)否, 采購員ID, 可采購否, 采購項目, 單位, 是否為庫存, 是否批量, 是否要預(yù)留, 能否庫存, 固定提前期, 固定批量大小, 庫存計劃方法, 最大定單數(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。 and = and = 142 and = (+) and (+) = 142 and (+) = 2 and = (+) and (+) = to_date(39。, 39。 and = 119 and = and = 39。1473000543639。STANDARD39。STANDARD39。STANDARD39。申請單頭 (加對方訂單編號)SELECT 申請單頭ID, , OU_ID, 申請單編號, 創(chuàng)建日期, 編制人ID,