DBA Data[Home] [Help]

APPS.WMS_OP_RUNTIME_PVT_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1655: , MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

1651: ,mmtt.transaction_temp_id
1652: ,mmtt.SECONDARY_TRANSACTION_QUANTITY -- 13431255
1653: ,mmtt.SECONDARY_UOM_CODE -- 13431255
1654: FROM WMS_DISPATCHED_TASKS wdt
1655: , MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1656: , mtl_material_transactions_temp pmmtt
1657: WHERE WDT.TASK_ID=p_task_id
1658: AND WDT.transaction_temp_id=MMTT.transaction_temp_id
1659: AND mmtt.parent_line_id = pmmtt.transaction_temp_id (+)

Line 1656: , mtl_material_transactions_temp pmmtt

1652: ,mmtt.SECONDARY_TRANSACTION_QUANTITY -- 13431255
1653: ,mmtt.SECONDARY_UOM_CODE -- 13431255
1654: FROM WMS_DISPATCHED_TASKS wdt
1655: , MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
1656: , mtl_material_transactions_temp pmmtt
1657: WHERE WDT.TASK_ID=p_task_id
1658: AND WDT.transaction_temp_id=MMTT.transaction_temp_id
1659: AND mmtt.parent_line_id = pmmtt.transaction_temp_id (+)
1660: );

Line 1851: FROM mtl_material_transactions_temp MMTT

1847: ,mmtt.transaction_action_id
1848: ,mmtt.transaction_temp_id
1849: ,mmtt.SECONDARY_TRANSACTION_QUANTITY -- 13431255
1850: ,mmtt.SECONDARY_UOM_CODE -- 13431255
1851: FROM mtl_material_transactions_temp MMTT
1852: WHERE transaction_temp_id=p_source_task_id);
1853:
1854:
1855: END IF;