DBA Data[Home] [Help]

APPS.INV_TRX_RELIEF_C_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1818: MTL_MATERIAL_TRANSACTIONS_TEMP A

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