DBA Data[Home] [Help]

APPS.FLM_PURGE dependencies on WIP_ENTITIES

Line 94: FROM MTL_DEMAND MD, WIP_ENTITIES WE

90: into l_records_found
91: FROM DUAL
92: WHERE EXISTS
93: (SELECT 1
94: FROM MTL_DEMAND MD, WIP_ENTITIES WE
95: WHERE WE.WIP_ENTITY_ID = arg_wip_entity_id
96: AND MD.SUPPLY_SOURCE_TYPE = 5
97: AND MD.SUPPLY_SOURCE_HEADER_ID = WE.WIP_ENTITY_ID
98: AND MD.INVENTORY_ITEM_ID = WE.PRIMARY_ITEM_ID

Line 286: DELETE FROM WIP_ENTITIES

282: END IF;
283:
284: l_stmt_num := 495;
285:
286: DELETE FROM WIP_ENTITIES
287: WHERE WIP_ENTITY_ID = arg_wip_entity_id;
288:
289: arg_return_value := G_SUCCESS;
290: