APPS.EAM_OP_VALIDATE_PVT dependencies on WIP_REQUIREMENT_OPERATIONS

Line 170: from wip_requirement_operations wro

166: select count(*)
167: into l_inv_count
168: from dual
169: where exists (select 1
170: from wip_requirement_operations wro
171: where wro.wip_entity_id = p_wip_entity_id
172: and wro.organization_id = p_organization_id
173: and wro.operation_seq_num = p_operation_seq_num
174: and ( quantity_issued > 0 or

Line 683: from wip_requirement_operations

679:
680:
681: select count(*)
682: into l_count_mr
683: from wip_requirement_operations
684: where wip_entity_id = p_eam_op_rec.wip_entity_id
685: and organization_id = p_eam_op_rec.organization_id
686: and operation_seq_num = p_eam_op_rec.operation_seq_num;
687:

Line 1008: --WIP_REQUIREMENT_OPERATIONS. quantity_issued > 0

1004: RETURN 'N';
1005: END IF;
1006:
1007: --2.Is Materail Tx Done
1008: --WIP_REQUIREMENT_OPERATIONS. quantity_issued > 0
1009: BEGIN
1010: SELECT nvl(sum(quantity_issued), 0)
1011: INTO l_q_issued
1012: FROM wip_requirement_operations

Line 1012: FROM wip_requirement_operations

1008: --WIP_REQUIREMENT_OPERATIONS. quantity_issued > 0
1009: BEGIN
1010: SELECT nvl(sum(quantity_issued), 0)
1011: INTO l_q_issued
1012: FROM wip_requirement_operations
1013: WHERE wip_entity_id = p_wip_entity_id
1014: AND operation_seq_num = p_op_seq_num;
1015:
1016: IF l_q_issued > 0 THEN