加载中…OracleEBSMMT和MMTT的TRANSACTION_SOURCE_ID表关联TRANSACTION_SOURCE_TYPE_ID
(2025-02-26 21:14:13)
标签：
mtl_material_transactransaction_source_itransaction_source_t |
分类： OracleEBS库存模块 |
Oracle EBS
MTL_MATERIAL_TRANSACTIONS和MTL_MATERIAL_TRANSACTIONS_TEMP的
TRANSACTION_SOURCE_ID表 关联TRANSACTION_SOURCE_TYPE_ID
SELECT MMTT.TRANSACTION_SOURCE_ID,
CASE WHEN MMTT.TRANSACTION_SOURCE_TYPE_ID = 1 THEN (SELECT
'RSH_NUMBER: ' || RCV.SHIPMENT_NUM
FROM RCV_SHIPMENT_HEADERS RCV,
RCV_TRANSACTIONS RCVT
WHERE RCV.SHIPMENT_HEADER_ID = RCVT.SHIPMENT_HEADER_ID
AND RCVT.TRANSACTION_ID = MMTT.TRANSACTION_SOURCE_ID)
WHEN MMTT.TRANSACTION_SOURCE_TYPE_ID = 2 THEN (SELECT
'SO_NUMBER: ' || SEGMENT1
FROM MTL_SALES_ORDERS
WHERE SALES_ORDER_ID = MMTT.TRANSACTION_SOURCE_ID)
WHEN MMTT.TRANSACTION_SOURCE_TYPE_ID = 4 THEN (SELECT
'MO_NUMBER: ' || REQUEST_NUMBER
FROM MTL_TXN_REQUEST_HEADERS
WHERE REQUEST_NUMBER =
TO_CHAR(MMTT.TRANSACTION_SOURCE_ID))
WHEN MMTT.TRANSACTION_SOURCE_TYPE_ID = 5 THEN (SELECT
'WIP_NUMBER: ' || WIP_ENTITY_NAME
FROM WIP_ENTITIES
WHERE WIP_ENTITY_ID = MMTT.TRANSACTION_SOURCE_ID)
WHEN MMTT.TRANSACTION_SOURCE_TYPE_ID = 7 THEN (SELECT
'INT_REQ_NUMBER: ' || RCV.SHIPMENT_NUM
FROM RCV_SHIPMENT_HEADERS RCV,
RCV_TRANSACTIONS RCVT
WHERE RCV.SHIPMENT_HEADER_ID = RCVT.SHIPMENT_HEADER_ID
AND RCVT.TRANSACTION_ID = MMTT.TRANSACTION_SOURCE_ID)
WHEN MMTT.TRANSACTION_SOURCE_TYPE_ID = 8 THEN (SELECT
'INT_SO_NUMBER: ' || SEGMENT1
FROM MTL_SALES_ORDERS
WHERE SALES_ORDER_ID = MMTT.TRANSACTION_SOURCE_ID)
WHEN MMTT.TRANSACTION_SOURCE_TYPE_ID = 10 THEN (SELECT
'PHY_NAME: ' || PHYSICAL_INVENTORY_NAME
FROM MTL_PHYSICAL_INVENTORIES
WHERE PHYSICAL_INVENTORY_ID =
MMTT.TRANSACTION_SOURCE_ID)
WHEN MMTT.TRANSACTION_SOURCE_TYPE_ID = 5 THEN (SELECT
'WIP_NUMBER: ' || WIP_ENTITY_NAME
FROM WIP_ENTITIES
WHERE WIP_ENTITY_ID = MMTT.TRANSACTION_SOURCE_ID)
ELSE 'NULL' END SRC_NUMBER
FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT;
a) TRANSACTION_SOURCE_ID: Job or Schedule
WIP_ENTITIES.WIP_ENTITY_ID
TRANSACTION_SOURCE_TYPE_ID = 5
b) TRANSACTION_SOURCE_ID: Sales Order
MTL_SALES_ORDERS.SALES_ORDER_ID
TRANSACTION_SOURCE_TYPE_ID = 2, 8
c) TRANSACTION_SOURCE_ID: Account Alias
MTL_GENERIC_DISPOSITIONS.DISPOSITION_ID
TRANSACTION_SOURCE_TYPE_ID = 6
d) TRANSACTION_SOURCE_ID: Purchase Order
PO_HEADERS_ALL.PO_HEADER_ID
TRANSACTION_SOURCE_TYPE_ID = 1
e) TRANSACTION_SOURCE_ID: Account
GL_CODE_COMBINATIONS.CODE_COMBINATION_ID
TRANSACTION_SOURCE_TYPE_ID = all others
--刘轶鹤
喜欢
0
赠金笔