APPS.AHL_COMPLETIONS_PVT dependencies on WIP_OPERATIONS

Line 2610: WIP_OPERATIONS WIOP

2606: IS
2607: SELECT
2608: WIOP.organization_id
2609: FROM
2610: WIP_OPERATIONS WIOP
2611: WHERE
2612: WIOP.wip_entity_id = p_wip_entity_id
2613: AND WIOP.operation_seq_num = p_operation_seq_num;
2614:

Line 5727: WIP_OPERATIONS WIP,

5723: WOP.status_code status_code,
5724: WOP.plan_id plan_id,
5725: WOP.collection_id collection_id
5726: FROM AHL_WORKORDER_OPERATIONS WOP,
5727: WIP_OPERATIONS WIP,
5728: AHL_WORKORDERS CWO
5729: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
5730: AND WOP.workorder_id = CWO.workorder_id
5731: AND WIP.wip_entity_id = CWO.wip_entity_id

Line 5776: WIP_OPERATIONS WIP,

5772: WOP.status_code status_code,
5773: WOP.plan_id plan_id,
5774: WOP.collection_id collection_id
5775: FROM AHL_WORKORDER_OPERATIONS WOP,
5776: WIP_OPERATIONS WIP,
5777: AHL_WORKORDERS CWO
5778: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
5779: AND WOP.workorder_id = CWO.workorder_id
5780: AND WIP.wip_entity_id = CWO.wip_entity_id

Line 7933: WIP_OPERATIONS WIP,

7929: WOP.status_code status_code,
7930: WOP.plan_id plan_id,
7931: WOP.collection_id collection_id
7932: FROM AHL_WORKORDER_OPERATIONS WOP,
7933: WIP_OPERATIONS WIP,
7934: AHL_WORKORDERS WO
7935: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
7936: AND WOP.workorder_id = WO.workorder_id
7937: AND WIP.wip_entity_id = WO.wip_entity_id

Line 9629: WIP_OPERATIONS WIP,

9625: CURSOR get_ue_operations( c_wip_entity_id NUMBER ) IS
9626: SELECT WOP.workorder_id workorder_id,
9627: WIP.operation_seq_num operation_seq_num
9628: FROM AHL_WORKORDER_OPERATIONS WOP,
9629: WIP_OPERATIONS WIP,
9630: AHL_WORKORDERS CWO
9631: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
9632: AND WOP.workorder_id = CWO.workorder_id
9633: AND WIP.wip_entity_id = CWO.wip_entity_id