APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on PO_REQUISITION_LINES_ALL

Line 614: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

610: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
611:
612: UNION ALL
613: SELECT SUM(nvl(prla.quantity,0)) req_qty
614: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
615: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
616: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
617: AND UPPER(NVL(prla.cancel_flag,'N')) <> 'Y'
618: AND prla.wip_entity_id =l_di_record.wip_entity_id

Line 638: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

634: AND pl.item_id is null
635: AND pd.wip_resource_seq_num = l_di_record.direct_item_sequence_id
636: AND pd.line_location_id not in(
637: SELECT nvl(prla.line_location_id,0)
638: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
639: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
640: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
641: AND UPPER(NVL(prla.cancel_flag,'N')) <> 'Y'
642: AND prla.wip_entity_id =l_di_record.wip_entity_id

Line 670: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

666: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
667:
668: UNION ALL
669: SELECT SUM(nvl(prla.quantity,0)) req_qty
670: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
671: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
672: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
673: AND prla.wip_entity_id =l_di_record.wip_entity_id
674: AND prla.destination_organization_id = l_di_record.organization_id

Line 692: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

688: AND pl.item_id is null
689: AND pd.wip_resource_seq_num = l_di_record.direct_item_sequence_id
690: AND pd.line_location_id not in(
691: SELECT nvl(prla.line_location_id,0)
692: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
693: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
694: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
695: AND prla.wip_entity_id =l_di_record.wip_entity_id
696: AND prla.destination_organization_id = l_di_record.organization_id

Line 732: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

728: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
729:
730: UNION ALL
731: SELECT SUM(nvl(prla.quantity,0)) req_qty
732: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
733: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
734: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
735: AND UPPER(NVL(prla.cancel_flag,'N')) <> 'Y'
736: AND prla.wip_entity_id = l_di_record.wip_entity_id

Line 756: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

752: AND pl.item_id = l_di_record.inventory_item_id
753: AND pd.wip_resource_seq_num is null
754: AND pd.line_location_id not in(
755: SELECT nvl(prla.line_location_id,0)
756: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
757: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
758: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('CANCELLED', 'REJECTED','SYSTEM_SAVED')
759: AND UPPER(NVL(prla.cancel_flag,'N')) <> 'Y'
760: AND prla.wip_entity_id =l_di_record.wip_entity_id

Line 791: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

787: AND ((process_flag is null) or (Upper(Trim(process_flag)) = 'IN PROCESS'))
788:
789: UNION ALL
790: SELECT SUM(nvl(prla.quantity,0)) req_qty
791: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
792: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
793: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
794: AND prla.wip_entity_id = l_di_record.wip_entity_id
795: AND prla.destination_organization_id = l_di_record.organization_id

Line 813: FROM po_requisition_lines_all prla , po_requisition_headers_all prha

809: AND pl.item_id = l_di_record.inventory_item_id
810: AND pd.wip_resource_seq_num is null
811: AND pd.line_location_id not in(
812: SELECT nvl(prla.line_location_id,0)
813: FROM po_requisition_lines_all prla , po_requisition_headers_all prha
814: WHERE prla.requisition_header_id = prha.requisition_header_id(+)
815: AND upper(NVL(prha.authorization_status, 'APPROVED') ) not in ('SYSTEM_SAVED')
816: AND prla.wip_entity_id =l_di_record.wip_entity_id
817: AND prla.destination_organization_id = l_di_record.organization_id