DBA Data[Home] [Help]

APPS.WIP_WS_EXCEPTIONS dependencies on WIP_OP_RESOURCE_INSTANCES

Line 439: FROM WIP_OP_RESOURCE_INSTANCES

435:
436: SAVEPOINT WIPVEXC;
437:
438: SELECT COUNT(*) INTO L_ROW_COUNT
439: FROM WIP_OP_RESOURCE_INSTANCES
440: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID AND
441: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
442: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
443: RESOURCE_SEQ_NUM = P_RESOURCE_SEQ_NUM AND

Line 459: FROM WIP_OP_RESOURCE_INSTANCES

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
460: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID AND
461: WIP_ENTITY_ID = P_WIP_ENTITY_ID AND
462: OPERATION_SEQ_NUM = P_OPERATION_SEQ_NUM AND
463: RESOURCE_SEQ_NUM = P_RESOURCE_SEQ_NUM AND