APPS.FLM_PURGE dependencies on MTL_DEMAND

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 102: arg_table_name := arg_table_name||' MTL_DEMAND *';

98: AND MD.INVENTORY_ITEM_ID = WE.PRIMARY_ITEM_ID
99: AND MD.ORGANIZATION_ID = arg_org_id);
100:
101: if (l_records_found <> 0) then
102: arg_table_name := arg_table_name||' MTL_DEMAND *';
103: l_flag := FALSE;
104: end if;
105:
106: l_stmt_num := 360;