DBA Data[Home] [Help]

APPS.INV_TRX_RELIEF_C_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1815: MTL_MATERIAL_TRANSACTIONS_TEMP A

1811: A.TRANSACTION_SOURCE_NAME,
1812: FND_DATE.DATE_TO_CANONICAL(A.TRANSACTION_DATE) TRANSACTION_DATE
1813: FROM MTL_SYSTEM_ITEMS C,
1814: MTL_TRANSACTION_LOTS_TEMP B,
1815: MTL_MATERIAL_TRANSACTIONS_TEMP A
1816: WHERE A.TRANSACTION_HEADER_ID = p_transaction_header_id
1817: AND A.ORGANIZATION_ID = C.ORGANIZATION_ID
1818: AND A.INVENTORY_ITEM_ID = C.INVENTORY_ITEM_ID
1819: AND B.TRANSACTION_TEMP_ID (+) = A.TRANSACTION_TEMP_ID