APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_RELEASES

Line 9678: FROM po_releases

9674: --
9675: --
9676: SELECT 'Y'
9677: INTO l_po_release_is_valid_flag
9678: FROM po_releases
9679: WHERE po_release_id = l_po_release_id
9680: /* For bug 4038403. Added by lgopalsa
9681: Need to validate the lines for matching */
9682: and nvl(authorization_status, 'INCOMPLETE') in ('APPROVED',

Line 9728: FROM po_releases

9724: SELECT 'Y',
9725: po_release_id
9726: INTO l_po_release_is_valid_flag,
9727: l_po_release_id
9728: FROM po_releases
9729: WHERE release_num = p_invoice_lines_rec.release_num
9730: AND po_header_id = l_po_header_id
9731: /* For bug 4038403
9732: Need to validate the lines for matching */

Line 9781: FROM po_releases

9777: END IF;
9778: --
9779: SELECT 'Y'
9780: INTO l_po_rel_is_consistent_flag
9781: FROM po_releases
9782: WHERE release_num = p_invoice_lines_rec.release_num
9783: AND po_release_id = l_po_release_id;
9784: EXCEPTION
9785: WHEN NO_DATA_FOUND THEN

Line 9978: from po_releases por, po_headers poh

9974: and pol.po_line_id = nvl(l_po_line_id, pol.po_line_id)
9975: and pol.line_num = p_invoice_lines_rec.po_line_number )
9976: AND po_release_id = (
9977: select po_release_id
9978: from po_releases por, po_headers poh
9979: where poh.po_header_id = por.po_header_id
9980: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
9981: -- fix for bug 2809177 commented above line and wrote the below one
9982: and poh.po_header_id = l_po_header_id

Line 10006: from po_releases por, po_headers poh

10002: and pol.po_line_id = nvl(l_po_line_id, pol.po_line_id)
10003: and pol.line_num = p_invoice_lines_rec.po_line_number )
10004: AND po_release_id = (
10005: select po_release_id
10006: from po_releases por, po_headers poh
10007: where poh.po_header_id = por.po_header_id
10008: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
10009: -- and poh.segment1 = nvl(p_invoice_lines_rec.po_number, poh.segment1)
10010: -- fix for bug 2809177 commented above two line and wrote the below one

Line 11569: po_releases pr

11565: ph.segment1
11566: INTO l_po_header_id,
11567: l_po_number
11568: FROM po_headers ph,
11569: po_releases pr
11570: WHERE pr.po_release_id = l_po_release_id
11571: AND pr.po_header_id = ph.po_header_id;
11572: EXCEPTION
11573: WHEN NO_DATA_FOUND THEN

Line 12230: po_releases pr

12226:
12227: SELECT 'X'
12228: INTO l_po_is_not_blanket
12229: FROM po_line_locations pll,
12230: po_releases pr
12231: WHERE pr.po_header_id = l_po_header_id
12232: AND pr.po_release_id = l_po_release_id
12233: AND pll.po_release_id = pr.po_release_id
12234: AND pll.po_line_id = l_po_line_id

Line 16081: po_releases_all PR ,

16077: FROM rcv_transactions RT ,
16078: rcv_shipment_headers SH ,
16079: po_headers_all PH ,
16080: po_line_locations_all PS ,
16081: po_releases_all PR ,
16082: per_all_people_f BU
16083: WHERE RT.po_line_location_id = p_invoice_lines_rec.po_line_location_id
16084: AND SH.receipt_num = nvl(p_invoice_lines_rec.receipt_number,sh.receipt_num)
16085: AND RT.transaction_id = nvl(p_invoice_lines_rec.rcv_transaction_id, RT.transaction_id)