APPS.WIP_WS_EXCEPTIONS dependencies on BOM_RESOURCE_EQUIPMENTS

Line 382: FROM BOM_RESOURCE_EQUIPMENTS

378: SAVEPOINT WIPVEXC;
379:
380: SELECT INVENTORY_ITEM_ID
381: INTO L_EQUIP_ITEM_ID
382: FROM BOM_RESOURCE_EQUIPMENTS
383: WHERE INSTANCE_ID = P_INSTANCE_ID;
384:
385: /*Remember although, for Equipment type exceptions,
386: * Serial number cannot be null, we still keep a check for it here.

Line 455: FROM BOM_RESOURCE_EQUIPMENTS BRE

451:
452: /* Get inventory_item_id, since we don't have instance_id in wip_exceptions*/
453: SELECT INVENTORY_ITEM_ID
454: INTO L_EQUIP_ITEM_ID
455: FROM BOM_RESOURCE_EQUIPMENTS BRE
456: WHERE INSTANCE_ID = P_INSTANCE_ID;
457:
458: SELECT SERIAL_NUMBER INTO L_SERIAL_NUMBER
459: FROM WIP_OP_RESOURCE_INSTANCES