APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_RELEASES

Line 8704: FROM po_releases

8700: --
8701: --
8702: SELECT 'Y'
8703: INTO l_po_release_is_valid_flag
8704: FROM po_releases
8705: WHERE po_release_id = l_po_release_id
8706: /* For bug 4038403. Added by lgopalsa
8707: Need to validate the lines for matching */
8708: and nvl(authorization_status, 'INCOMPLETE') in ('APPROVED',

Line 8753: FROM po_releases

8749: SELECT 'Y',
8750: po_release_id
8751: INTO l_po_release_is_valid_flag,
8752: l_po_release_id
8753: FROM po_releases
8754: WHERE release_num = p_invoice_lines_rec.release_num
8755: AND po_header_id = l_po_header_id
8756: /* For bug 4038403
8757: Need to validate the lines for matching */

Line 8805: FROM po_releases

8801: END IF;
8802: --
8803: SELECT 'Y'
8804: INTO l_po_rel_is_consistent_flag
8805: FROM po_releases
8806: WHERE release_num = p_invoice_lines_rec.release_num
8807: AND po_release_id = l_po_release_id;
8808: EXCEPTION
8809: WHEN NO_DATA_FOUND THEN

Line 8997: from po_releases por, po_headers poh

8993: and pol.po_line_id = nvl(l_po_line_id, pol.po_line_id)
8994: and pol.line_num = p_invoice_lines_rec.po_line_number )
8995: AND po_release_id = (
8996: select po_release_id
8997: from po_releases por, po_headers poh
8998: where poh.po_header_id = por.po_header_id
8999: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
9000: -- fix for bug 2809177 commented above line and wrote the below one
9001: and poh.po_header_id = l_po_header_id

Line 9025: from po_releases por, po_headers poh

9021: and pol.po_line_id = nvl(l_po_line_id, pol.po_line_id)
9022: and pol.line_num = p_invoice_lines_rec.po_line_number )
9023: AND po_release_id = (
9024: select po_release_id
9025: from po_releases por, po_headers poh
9026: where poh.po_header_id = por.po_header_id
9027: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
9028: -- and poh.segment1 = nvl(p_invoice_lines_rec.po_number, poh.segment1)
9029: -- fix for bug 2809177 commented above two line and wrote the below one

Line 10480: po_releases pr

10476: ph.segment1
10477: INTO l_po_header_id,
10478: l_po_number
10479: FROM po_headers ph,
10480: po_releases pr
10481: WHERE pr.po_release_id = l_po_release_id
10482: AND pr.po_header_id = ph.po_header_id;
10483: EXCEPTION
10484: WHEN NO_DATA_FOUND THEN

Line 11112: po_releases pr

11108:
11109: SELECT 'X'
11110: INTO l_po_is_not_blanket
11111: FROM po_line_locations pll,
11112: po_releases pr
11113: WHERE pr.po_header_id = l_po_header_id
11114: AND pr.po_release_id = l_po_release_id
11115: AND pll.po_release_id = pr.po_release_id
11116: AND pll.po_line_id = l_po_line_id

Line 14687: po_releases_all PR ,

14683: FROM rcv_transactions RT ,
14684: rcv_shipment_headers SH ,
14685: po_headers_all PH ,
14686: po_line_locations_all PS ,
14687: po_releases_all PR ,
14688: per_all_people_f BU
14689: WHERE RT.po_line_location_id = p_invoice_lines_rec.po_line_location_id
14690: AND SH.receipt_num = nvl(p_invoice_lines_rec.receipt_number,sh.receipt_num)
14691: AND RT.transaction_id = nvl(p_invoice_lines_rec.rcv_transaction_id, RT.transaction_id)