eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_OPERATIONS_UTILITIES dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 906: AND NOT EXISTS (SELECT 1 FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

902: WHERE ORGANIZATION_ID = X_Organization_Id
903: AND WIP_ENTITY_ID = X_Wip_Entity_Id
904: AND OPERATION_SEQ_NUM in (1,-1)
905: AND QUANTITY_ISSUED=0
906: AND NOT EXISTS (SELECT 1 FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
907: WHERE MMTT.TRANSACTION_SOURCE_ID=X_Wip_Entity_Id and MMTT.organization_id=X_Organization_Id and MMTT.operation_seq_num in (-1,1)
908: and MMTT.inventory_item_id=WRO.INVENTORY_ITEM_ID AND mmtt.transaction_source_type_id=INV_Globals.G_SOURCETYPE_WIP);
909: ELSE
910: UPDATE WIP_REQUIREMENT_OPERATIONS wro

Line 920: AND NOT EXISTS (SELECT 1 FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

916: AND WIP_ENTITY_ID = X_Wip_Entity_Id
917: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
918: AND OPERATION_SEQ_NUM IN (1,-1)
919: AND QUANTITY_ISSUED=0
920: AND NOT EXISTS (SELECT 1 FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
921: WHERE TRANSACTION_SOURCE_ID=X_Wip_Entity_Id and MMTT.organization_id=X_Organization_Id AND MMTT.repetitive_line_id=X_Repetitive_Schedule_Id and
922: MMTT.operation_seq_num in (-1,1) and MMTT.inventory_item_id=WRO.INVENTORY_ITEM_ID and mmtt.transaction_source_type_id=INV_Globals.G_SOURCETYPE_WIP);
923:
924: END IF;