DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on MTL_USER_DEMAND

Line 1292: x_purge_rec.table_name := 'MTL_USER_DEMAND';

1288: append_report(x_purge_rec, p_option);
1289: end if;
1290:
1291:
1292: x_purge_rec.table_name := 'MTL_USER_DEMAND';
1293:
1294:
1295: if (x_purge_rec.primary_item_id IS NULL) then
1296:

Line 1302: FROM MTL_USER_DEMAND

1298: into x_records_returned
1299: FROM DUAL
1300: WHERE EXISTS
1301: (SELECT 1
1302: FROM MTL_USER_DEMAND
1303: WHERE SOURCE_TYPE_ID = 4
1304: AND SOURCE_ID = x_purge_rec.wip_entity_id
1305: AND INVENTORY_ITEM_ID IS NULL );
1306: else

Line 1312: FROM MTL_USER_DEMAND

1308: into x_records_returned
1309: FROM DUAL
1310: WHERE EXISTS
1311: (SELECT 1
1312: FROM MTL_USER_DEMAND
1313: WHERE SOURCE_TYPE_ID = 4
1314: AND SOURCE_ID = x_purge_rec.wip_entity_id
1315: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id );
1316: