eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_LINE_LOCATIONS

Line 6384: po_line_locations pll

6380: SELECT count(*)
6381: INTO l_count_lines_matched
6382: FROM ap_invoice_lines ail,
6383: ap_invoices ai,
6384: po_line_locations pll
6385: WHERE ai.invoice_num = p_invoice_rec.prepay_num
6386: AND ai.org_id = p_invoice_rec.org_id
6387: AND ail.invoice_id = ai.invoice_id
6388: AND ail.po_line_location_id = pll.line_location_id

Line 9178: l_accrue_on_receipt_flag po_line_locations.accrue_on_receipt_flag%TYPE;

9174: l_correction_dist_amount NUMBER;
9175: l_shipment_finally_closed VARCHAR2(1);
9176: l_corrupt_po_distributions NUMBER;
9177: l_calc_line_amount NUMBER;
9178: l_accrue_on_receipt_flag po_line_locations.accrue_on_receipt_flag%TYPE;
9179: l_temp_match_option VARCHAR2(25); --Bug5225547
9180: l_item_description VARCHAR2(240); --Bug8546486
9181:
9182: l_price_cor_po_header_id NUMBER; --bug13599126

Line 9822: FROM po_line_locations

9818: END IF;
9819: --
9820: SELECT 'Y'
9821: INTO l_po_rel_is_consistent_flag
9822: FROM po_line_locations
9823: WHERE po_line_id = l_po_line_id
9824: AND po_release_id = l_po_release_id
9825: /*Bug 2787396 we need to validate the shipment level for matching */
9826: AND nvl(approved_flag, 'N' ) = 'Y'

Line 9866: FROM po_line_locations

9862: END IF;
9863: --
9864: SELECT DISTINCT po_line_id
9865: INTO l_po_line_id
9866: FROM po_line_locations
9867: WHERE po_release_id = l_po_release_id
9868: /* For bug 4038403
9869: we should check at line location level approved flag
9870: as we can do invoicing for the line/shipment for which

Line 9963: FROM po_line_locations

9959:
9960: IF l_po_header_id IS NOT NULL THEN -- Fix for 2809177
9961: SELECT 'Y'
9962: INTO l_po_rel_is_consistent_flag
9963: FROM po_line_locations
9964: WHERE po_line_id = (
9965: select po_line_id
9966: from po_lines pol, po_headers poh
9967: where poh.po_header_id = pol.po_header_id

Line 9992: FROM po_line_locations

9988: AND rownum <=1;
9989: ELSIF p_invoice_lines_rec.po_number IS NOT NULL THEN
9990: SELECT 'Y'
9991: INTO l_po_rel_is_consistent_flag
9992: FROM po_line_locations
9993: WHERE po_line_id = (
9994: select po_line_id
9995: from po_lines pol, po_headers poh
9996: where poh.po_header_id = pol.po_header_id

Line 10350: , po_line_locations pll

10346: THEN
10347: SELECT 'Y'
10348: INTO l_po_line_is_consistent_flag
10349: FROM po_lines pl
10350: , po_line_locations pll
10351: WHERE pl.item_id = p_invoice_lines_rec.inventory_item_id
10352: AND nvl(pll.description, pl.item_description) like p_invoice_lines_rec.item_description
10353: AND pl.po_header_id = pll.po_header_id
10354: AND pll.po_header_id = l_po_header_id

Line 10723: FROM po_line_locations

10719: END IF;
10720: --
10721: SELECT 'Y'
10722: INTO l_po_shipment_is_valid_flag
10723: FROM po_line_locations
10724: WHERE line_location_id = l_po_line_location_id
10725: /* For bug 4038403
10726: Need to check the validation for
10727: line location approved_flag */

Line 10779: FROM po_line_locations

10775: --
10776:
10777: SELECT 'Y', line_location_id
10778: INTO l_po_shipment_is_valid_flag, l_po_line_location_id
10779: FROM po_line_locations
10780: WHERE shipment_num = p_invoice_lines_rec.po_shipment_num
10781: AND po_header_id = l_po_header_id
10782: AND po_line_id = l_po_line_id
10783: AND NVL(closed_code, 'X') <> 'FINALLY CLOSED'; --Bug#13867905;

Line 10857: FROM po_line_locations pll,

10853: --
10854:
10855: SELECT 'Y', line_location_id
10856: INTO l_po_shipment_is_valid_flag, l_po_line_location_id
10857: FROM po_line_locations pll,
10858: hr_locations hl
10859: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
10860: AND hl.location_id = pll.ship_to_location_id
10861: AND pll.po_header_id = l_po_header_id

Line 10931: FROM po_line_locations

10927: SELECT 'Y', line_location_id,
10928: po_line_id
10929: INTO l_po_shipment_is_valid_flag, l_po_line_location_id,
10930: l_po_line_id
10931: FROM po_line_locations
10932: WHERE shipment_num = p_invoice_lines_rec.po_shipment_num
10933: AND po_header_id = l_po_header_id
10934: AND po_release_id = l_po_release_id
10935: AND NVL(closed_code, 'X') <> 'FINALLY CLOSED'; --Bug#13867905;

Line 10985: FROM po_line_locations pll, hr_locations hl

10981: SELECT 'Y', line_location_id,
10982: po_line_id
10983: INTO l_po_shipment_is_valid_flag, l_po_line_location_id,
10984: l_po_line_id
10985: FROM po_line_locations pll, hr_locations hl
10986: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
10987: AND hl.location_id = pll.ship_to_location_id
10988: AND pll.po_header_id = l_po_header_id
10989: AND pll.po_release_id = l_po_release_id;

Line 11035: FROM po_line_locations

11031: END IF;
11032: --
11033: SELECT 'Y'
11034: INTO l_po_shipment_is_consis_flag
11035: FROM po_line_locations
11036: WHERE shipment_num = p_invoice_lines_rec.po_shipment_num
11037: AND line_location_id = l_po_line_location_id;
11038: EXCEPTION
11039: WHEN NO_DATA_FOUND THEN

Line 11078: FROM po_line_locations pll,

11074: --
11075:
11076: SELECT 'Y'
11077: INTO l_po_shipment_is_consis_flag
11078: FROM po_line_locations pll,
11079: hr_locations hl
11080: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
11081: AND hl.location_id = pll.ship_to_location_id
11082: AND line_location_id = l_po_line_location_id;

Line 11126: FROM po_line_locations pll,

11122: END IF;
11123: --
11124: SELECT 'Y'
11125: INTO l_po_shipment_is_consis_flag
11126: FROM po_line_locations pll,
11127: hr_locations hl
11128: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
11129: AND hl.location_id = pll.ship_to_location_id
11130: AND po_line_id = l_po_line_id

Line 11191: FROM po_line_locations

11187: --
11188:
11189: SELECT NVL(accrue_on_receipt_flag, 'N')
11190: INTO l_accrue_on_receipt_flag
11191: FROM po_line_locations
11192: WHERE ((shipment_num = p_invoice_lines_rec.po_shipment_num
11193: AND p_invoice_lines_rec.po_shipment_num IS NOT NULL
11194: AND p_invoice_lines_rec.po_line_location_id IS NULL)
11195: OR (line_location_id = p_invoice_lines_rec.po_line_location_id

Line 11263: FROM po_line_locations pll,

11259: END IF;
11260: --
11261: SELECT 'Y'
11262: INTO l_po_shipment_is_consis_flag
11263: FROM po_line_locations pll,
11264: hr_locations hl
11265: WHERE hl.location_code = p_invoice_lines_rec.ship_to_location_code
11266: AND hl.location_id = pll.ship_to_location_id
11267: AND po_release_id = l_po_release_id

Line 11604: po_line_locations pll

11600: ph.segment1
11601: INTO l_po_header_id,
11602: l_po_number
11603: FROM po_headers ph,
11604: po_line_locations pll
11605: WHERE pll.line_location_id = l_po_line_location_id
11606: AND pll.po_header_id = ph.po_header_id;
11607: EXCEPTION
11608: WHEN NO_DATA_FOUND THEN

Line 11708: FROM po_line_locations

11704: END IF;
11705:
11706: SELECT po_line_id
11707: INTO l_po_line_id
11708: FROM po_line_locations
11709: WHERE line_location_id = l_po_line_location_id;
11710: EXCEPTION
11711: WHEN NO_DATA_FOUND THEN
11712: NULL;

Line 11883: FROM po_line_locations pll

11879: +---------------------------------------------------------------------*/
11880:
11881: SELECT line_location_id
11882: INTO l_po_line_location_id
11883: FROM po_line_locations pll
11884: WHERE po_header_id = l_po_header_id
11885: AND po_line_id = l_po_line_id
11886: AND
11887: (

Line 11945: FROM po_line_locations pll

11941: l_po_line_location_id IS NOT NULL)THEN
11942:
11943: SELECT pll.ship_to_location_id
11944: INTO p_invoice_lines_rec.ship_to_location_id
11945: FROM po_line_locations pll
11946: WHERE pll.line_location_id = l_po_line_location_id;
11947:
11948: END IF;
11949: --Bug#14118812

Line 11968: FROM po_line_locations pll

11964: END IF;
11965:
11966: SELECT pll.matching_basis,pll.description-- Bug8546486
11967: INTO l_match_basis,l_item_description -- Bug8546486
11968: FROM po_line_locations pll
11969: WHERE pll.line_location_id = l_po_line_location_id;
11970:
11971: END IF;
11972:

Line 11974: po_line_locations_all table level*/

11970:
11971: END IF;
11972:
11973: /*Bug8546486 fetching the Description if it is not present at
11974: po_line_locations_all table level*/
11975: IF (l_item_description IS NULL and l_po_line_id IS NOT NULL) THEN
11976:
11977: SELECT pl.item_description
11978: INTO l_item_description

Line 12031: po_line_locations pll

12027:
12028: SELECT COUNT(*)
12029: INTO l_corrupt_po_distributions
12030: FROM po_distributions pod,
12031: po_line_locations pll
12032: WHERE pod.po_header_id = l_po_header_id
12033: AND pod.line_location_id = pll.line_location_id
12034: AND ((pll.matching_basis = 'QUANTITY'
12035: AND pod.quantity_ordered IS NULL)

Line 12229: FROM po_line_locations pll,

12225: END IF;
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

Line 12692: FROM ap_invoice_lines ail, po_line_locations pll

12688: END IF;
12689:
12690: SELECT 'Y'
12691: INTO l_shipment_finally_closed
12692: FROM ap_invoice_lines ail, po_line_locations pll
12693: WHERE ail.invoice_id = l_price_correct_inv_id
12694: AND ail.line_number = p_invoice_lines_rec.price_correct_inv_line_num
12695: AND pll.line_location_id = ail.po_line_location_id
12696: AND pll.closed_code = 'FINALLY CLOSED';

Line 13401: FROM po_line_locations

13397:
13398: BEGIN
13399: SELECT line_location_id
13400: INTO l_po_line_location_id
13401: FROM po_line_locations
13402: WHERE po_header_id = l_po_header_id
13403: AND po_line_id = l_po_line_id
13404: AND shipment_num = p_invoice_lines_rec.po_shipment_num ;
13405: EXCEPTION

Line 13439: From po_line_locations

13435: END IF;
13436:
13437: Select nvl(match_option,'P')
13438: Into l_temp_match_option
13439: From po_line_locations
13440: Where line_location_id = l_po_line_location_id;
13441:
13442: If (l_temp_match_option is not null) then
13443:

Line 13566: FROM po_line_locations

13562:
13563: -- 7531219 replaced p_invoice_lines_rec.po_line_location_id with l_po_line_location_id
13564: SELECT NVL(accrue_on_receipt_flag, 'N')
13565: INTO l_accrue_on_receipt_flag
13566: FROM po_line_locations
13567: WHERE ((shipment_num = p_invoice_lines_rec.po_shipment_num
13568: AND p_invoice_lines_rec.po_shipment_num IS NOT NULL
13569: AND p_invoice_lines_rec.po_line_location_id IS NULL)
13570: OR (line_location_id = l_po_line_location_id --p_invoice_lines_rec.po_line_location_id

Line 13868: l_temp_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;

13864: l_temp_match_option VARCHAR2(25);
13865: current_calling_sequence VARCHAR2(2000);
13866: debug_info VARCHAR2(500);
13867: l_line_amount NUMBER; /* Amount Based Matching */
13868: l_temp_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
13869:
13870: BEGIN
13871:
13872: -- Update the calling sequence

Line 13906: po_line_locations pll

13902: --Standard/Blanket/Scheduled shipments are valid for Standard/Credit invoices.
13903: SELECT 'X'
13904: INTO l_invalid_shipment_type
13905: FROM po_distributions pd,
13906: po_line_locations pll
13907: WHERE pd.line_location_id = pll.line_location_id
13908: AND pd.po_distribution_id = l_po_distribution_id
13909: AND
13910: (

Line 13961: FROM po_line_locations pll

13957: --Standard/Blanket/Scheduled shipments are valid for Standard/Credit invoices.
13958: BEGIN
13959: SELECT 'X'
13960: INTO l_invalid_shipment_type
13961: FROM po_line_locations pll
13962: WHERE line_location_id = l_po_line_location_id
13963: AND(
13964: --(p_invoice_rec.invoice_type_lookup_code <> 'PREPAYMENT' and .. B# 8528132
13965: (nvl(p_invoice_rec.invoice_type_lookup_code, 'STANDARD') <> 'PREPAYMENT' and -- B# 8528132

Line 14011: FROM po_line_locations

14007: END IF;
14008:
14009: SELECT nvl(match_option,'P')
14010: INTO l_temp_match_option
14011: FROM po_line_locations
14012: WHERE line_location_id = l_po_line_location_id;
14013:
14014: --bug 9292033 : modified below condition to allow prepayment invoices with match option as 'P' and 'R' on PO
14015:

Line 14064: FROM po_line_locations pll

14060:
14061: BEGIN
14062: SELECT count(*)
14063: INTO l_invalid_shipment_count
14064: FROM po_line_locations pll
14065: WHERE pll.po_line_id = l_po_line_id
14066: AND(
14067: (
14068: --(p_invoice_rec.invoice_type_lookup_code <> 'PREPAYMENT' and .. B# 8528132

Line 14184: From po_line_locations

14180: IF l_po_line_location_id IS NOT NULL THEN
14181:
14182: Select shipment_type
14183: Into l_temp_shipment_type
14184: From po_line_locations
14185: Where line_location_id = l_po_line_location_id;
14186:
14187: END IF;
14188:

Line 14299: FROM po_line_locations pll

14295: --bug2878889.Commented the following code and added the code below.
14296: /* IF (l_po_line_location_id IS NOT NULL) THEN
14297: SELECT pll.price_override, pll.unit_meas_lookup_code
14298: INTO l_po_unit_price,l_unit_of_measure
14299: FROM po_line_locations pll
14300: WHERE pll.line_location_id = l_po_line_location_id;
14301: ELSE
14302: SELECT unit_price,unit_meas_lookup_code
14303: INTO l_po_unit_price,l_unit_of_measure

Line 14314: FROM po_line_locations_release_v

14310: AND (p_invoice_lines_rec.po_release_id IS NOT NULL) ) THEN
14311:
14312: SELECT NVL(price_override,unit_price),unit_meas_lookup_code
14313: INTO l_po_unit_price,l_unit_of_measure
14314: FROM po_line_locations_release_v
14315: WHERE po_line_id = l_po_line_id
14316: -- bug7328060, added the below condition
14317: AND line_location_id = nvl(l_po_line_location_id, line_location_id)
14318: AND po_release_id = p_invoice_lines_rec.po_release_id;

Line 14327: FROM po_line_locations pll

14323: AND (p_invoice_lines_rec.po_release_id IS NULL) ) THEN
14324:
14325: SELECT pll.price_override, pll.unit_meas_lookup_code
14326: INTO l_po_unit_price,l_unit_of_measure
14327: FROM po_line_locations pll
14328: WHERE pll.line_location_id = l_po_line_location_id;
14329:
14330: ELSIF ( (l_po_line_id IS NOT NULL)
14331: /* Bug 9326135 AND (p_invoice_lines_rec.quantity_invoiced IS NULL)*/

Line 14864: po_line_locations PLL

14860: NVL(p_invoice_lines_rec.amount, l_line_amount)
14861: INTO l_total_qty_billed,
14862: l_total_match_amount /* Amount Based Matching */
14863: FROM ap_invoice_lines L,
14864: po_line_locations PLL
14865: WHERE L.po_line_location_id = PLL.line_location_id
14866: AND PLL.po_line_id = l_po_line_id;
14867:
14868: -- If total qty billed is below zero

Line 15405: CURSOR po_line_locations_cur IS

15401: AND nvl(accrue_on_receipt_flag,'N') <> 'Y' --Bug 2667171 added this Condition
15402: ORDER BY distribution_num;
15403:
15404: --Contract Payments: Modified the where clause
15405: CURSOR po_line_locations_cur IS
15406: SELECT pd.code_combination_id
15407: FROM po_distributions pd,
15408: po_line_locations pll
15409: WHERE pd.line_location_id = pll.line_location_id

Line 15408: po_line_locations pll

15404: --Contract Payments: Modified the where clause
15405: CURSOR po_line_locations_cur IS
15406: SELECT pd.code_combination_id
15407: FROM po_distributions pd,
15408: po_line_locations pll
15409: WHERE pd.line_location_id = pll.line_location_id
15410: AND pll.po_line_id = l_po_line_id
15411: AND(
15412: --(p_invoice_rec.invoice_type_lookup_code <> 'PREPAYMENT' and .. B# 8528132

Line 15639: '(v_check_po_overlay 1) Open po_line_locations ');

15635: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
15636: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15637: '(v_check_po_overlay 1) Get l_code_combination_id FROM l_po_line_id ');
15638: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15639: '(v_check_po_overlay 1) Open po_line_locations ');
15640: END IF;
15641:
15642: OPEN po_line_locations_cur;
15643:

Line 15642: OPEN po_line_locations_cur;

15638: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15639: '(v_check_po_overlay 1) Open po_line_locations ');
15640: END IF;
15641:
15642: OPEN po_line_locations_cur;
15643:
15644: LOOP
15645: --
15646: --

Line 15649: '(v_check_po_overlay 2) Fetch po_line_locations_cur ');

15645: --
15646: --
15647: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
15648: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15649: '(v_check_po_overlay 2) Fetch po_line_locations_cur ');
15650: END IF;
15651:
15652: FETCH po_line_locations_cur INTO l_code_combination_id;
15653: --

Line 15652: FETCH po_line_locations_cur INTO l_code_combination_id;

15648: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15649: '(v_check_po_overlay 2) Fetch po_line_locations_cur ');
15650: END IF;
15651:
15652: FETCH po_line_locations_cur INTO l_code_combination_id;
15653: --
15654: EXIT WHEN po_line_locations_cur%NOTFOUND OR
15655: po_line_locations_cur%NOTFOUND IS NULL;
15656:

Line 15654: EXIT WHEN po_line_locations_cur%NOTFOUND OR

15650: END IF;
15651:
15652: FETCH po_line_locations_cur INTO l_code_combination_id;
15653: --
15654: EXIT WHEN po_line_locations_cur%NOTFOUND OR
15655: po_line_locations_cur%NOTFOUND IS NULL;
15656:
15657: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
15658: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 15655: po_line_locations_cur%NOTFOUND IS NULL;

15651:
15652: FETCH po_line_locations_cur INTO l_code_combination_id;
15653: --
15654: EXIT WHEN po_line_locations_cur%NOTFOUND OR
15655: po_line_locations_cur%NOTFOUND IS NULL;
15656:
15657: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
15658: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15659: '------------------> l_code_combination_id = '||

Line 15690: CLOSE po_line_locations_cur;

15686: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15687: '(v_check_po_overlay 3) Overlay_Segments<-'
15688: ||current_calling_sequence);
15689: END IF;
15690: CLOSE po_line_locations_cur;
15691: Raise check_po_failure;
15692: ELSE
15693: -- show output values (only IF debug_switch = 'Y')
15694: --

Line 15721: CLOSE po_line_locations_cur;

15717: AP_IMPORT_UTILITIES_PKG.Print(
15718: AP_IMPORT_INVOICES_PKG.g_debug_switch,
15719: 'insert_rejections<-'||current_calling_sequence);
15720: END IF;
15721: CLOSE po_line_locations_cur;
15722: RAISE check_po_failure;
15723: --
15724: END IF; -- insert rejections
15725: l_current_invoice_status := 'N';

Line 15732: '(v_check_po_overlay 5) Close po_line_locations ');

15728:
15729: END LOOP;
15730: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
15731: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15732: '(v_check_po_overlay 5) Close po_line_locations ');
15733: END IF;
15734: CLOSE po_line_locations_cur;
15735: END IF; -- po distribution id is not NULL
15736: ELSE -- invoice status <> 'N'

Line 15734: CLOSE po_line_locations_cur;

15730: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
15731: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
15732: '(v_check_po_overlay 5) Close po_line_locations ');
15733: END IF;
15734: CLOSE po_line_locations_cur;
15735: END IF; -- po distribution id is not NULL
15736: ELSE -- invoice status <> 'N'
15737: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
15738: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,

Line 15790: l_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;

15786: l_cascade_receipts_flag VARCHAR2(1);
15787: l_price_correct_inv_id AP_INVOICES.INVOICE_ID%TYPE;
15788:
15789: --Contract Payments
15790: l_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
15791:
15792: BEGIN
15793:
15794: -- Update the calling sequence

Line 16080: po_line_locations_all PS ,

16076: INTO l_qty_billed_sum
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)

Line 22389: FROM po_lines_all pl, po_line_locations_all pll

22385:
22386: ELSE
22387: SELECT pl.category_id
22388: INTO l_purchasing_category_id
22389: FROM po_lines_all pl, po_line_locations_all pll
22390: WHERE pll.line_location_id = p_invoice_lines_rec.po_line_location_id
22391: AND pl.po_line_id = pll.po_line_id;
22392:
22393: END IF;