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 656: from wip_requirement_operations

652:
653:
654: select count(*)
655: into l_count_mr
656: from wip_requirement_operations
657: where wip_entity_id = p_eam_op_rec.wip_entity_id
658: and organization_id = p_eam_op_rec.organization_id
659: and operation_seq_num = p_eam_op_rec.operation_seq_num;
660:

Line 980: --WIP_REQUIREMENT_OPERATIONS. quantity_issued > 0

976: RETURN 'N';
977: END IF;
978:
979: --2.Is Materail Tx Done
980: --WIP_REQUIREMENT_OPERATIONS. quantity_issued > 0
981: BEGIN
982: SELECT nvl(sum(quantity_issued), 0)
983: INTO l_q_issued
984: FROM wip_requirement_operations

Line 984: FROM wip_requirement_operations

980: --WIP_REQUIREMENT_OPERATIONS. quantity_issued > 0
981: BEGIN
982: SELECT nvl(sum(quantity_issued), 0)
983: INTO l_q_issued
984: FROM wip_requirement_operations
985: WHERE wip_entity_id = p_wip_entity_id
986: AND operation_seq_num = p_op_seq_num;
987:
988: IF l_q_issued > 0 THEN