DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_UTILITIES dependencies on INV_GLOBALS

Line 908: and MMTT.inventory_item_id=WRO.INVENTORY_ITEM_ID AND mmtt.transaction_source_type_id=INV_Globals.G_SOURCETYPE_WIP);

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
911: SET OPERATION_SEQ_NUM = SIGN(OPERATION_SEQ_NUM) *
912: X_Operation_Seq_Num,

Line 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);

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;
925: END Update_Operationless_Reqs;
926: