DBA Data[Home] [Help]

APPS.WIP_WICTPG dependencies on MTL_USER_SUPPLY

Line 1257: x_purge_rec.table_name := 'MTL_USER_SUPPLY';

1253: end if;
1254:
1255:
1256:
1257: x_purge_rec.table_name := 'MTL_USER_SUPPLY';
1258:
1259:
1260: if (x_purge_rec.primary_item_id IS NULL) then
1261:

Line 1267: FROM MTL_USER_SUPPLY

1263: into x_records_returned
1264: FROM DUAL
1265: WHERE EXISTS
1266: (SELECT 1
1267: FROM MTL_USER_SUPPLY
1268: WHERE SOURCE_TYPE_ID = 4
1269: AND SOURCE_ID = x_purge_rec.wip_entity_id
1270: AND INVENTORY_ITEM_ID IS NULL );
1271:

Line 1279: FROM MTL_USER_SUPPLY

1275: into x_records_returned
1276: FROM DUAL
1277: WHERE EXISTS
1278: (SELECT 1
1279: FROM MTL_USER_SUPPLY
1280: WHERE SOURCE_TYPE_ID = 4
1281: AND SOURCE_ID = x_purge_rec.wip_entity_id
1282: AND INVENTORY_ITEM_ID = x_purge_rec.primary_item_id );
1283: end if;