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_LINES

Line 9436: FROM po_lines

9432: END IF;
9433: --
9434: SELECT 'Y'
9435: INTO l_po_line_is_valid_flag
9436: FROM po_lines
9437: WHERE po_line_id = l_po_line_id
9438: AND NVL(closed_code, 'X') <> 'FINALLY CLOSED'; --Bug#13867905;
9439:
9440: EXCEPTION

Line 9484: FROM po_lines pl

9480:
9481: BEGIN
9482: SELECT pl.po_header_id
9483: INTO l_po_header_id
9484: FROM po_lines pl
9485: WHERE pl.vendor_product_num = p_invoice_lines_rec.vendor_item_num;
9486: EXCEPTION
9487: WHEN NO_DATA_FOUND Then
9488: IF ( AP_IMPORT_INVOICES_PKG.g_source = 'XML GATEWAY' ) THEN

Line 9594: FROM po_lines

9590: --
9591: --
9592: SELECT 'Y', po_line_id
9593: INTO l_po_line_is_valid_flag, l_po_line_id
9594: FROM po_lines
9595: WHERE line_num = p_invoice_lines_rec.po_line_number
9596: AND po_header_id = l_po_header_id
9597: AND NVL(closed_code, 'X') <> 'FINALLY CLOSED'; --Bug#13867905;
9598: EXCEPTION

Line 9637: FROM po_lines

9633: END IF;
9634: --
9635: SELECT 'Y'
9636: INTO l_po_line_is_consistent_flag
9637: FROM po_lines
9638: WHERE line_num = p_invoice_lines_rec.po_line_number
9639: AND po_line_id = l_po_line_id;
9640: EXCEPTION
9641: WHEN NO_DATA_FOUND THEN

Line 9966: from po_lines pol, po_headers poh

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
9968: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
9969: -- fix for bug 2809177 commented above line and wrote the below one
9970: and poh.po_header_id = l_po_header_id

Line 9995: from po_lines pol, po_headers poh

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
9997: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
9998: -- and poh.segment1 = nvl(p_invoice_lines_rec.po_number, poh.segment1)
9999: -- fix for bug 2809177 commented above two lines and wrote the below one

Line 10055: FROM po_lines

10051: END IF;
10052: --
10053: SELECT 'Y', po_line_id
10054: INTO l_po_is_valid_flag, l_po_line_id
10055: FROM po_lines
10056: WHERE item_id = p_invoice_lines_rec.inventory_item_id
10057: AND po_header_id = l_po_header_id;
10058: EXCEPTION
10059: WHEN NO_DATA_FOUND THEN

Line 10122: FROM po_lines

10118: END IF;
10119: --
10120: SELECT 'Y', po_line_id
10121: INTO l_po_is_valid_flag, l_po_line_id
10122: FROM po_lines
10123: WHERE vendor_product_num = p_invoice_lines_rec.vendor_item_num
10124: AND po_header_id = l_po_header_id;
10125: EXCEPTION
10126: WHEN NO_DATA_FOUND THEN

Line 10196: FROM po_lines

10192: END IF;
10193: --
10194: SELECT 'Y', po_line_id
10195: INTO l_po_is_valid_flag, l_po_line_id
10196: FROM po_lines
10197: WHERE item_description like p_invoice_lines_rec.item_description
10198: AND po_header_id = l_po_header_id;
10199: EXCEPTION
10200: WHEN NO_DATA_FOUND THEN

Line 10271: FROM po_lines

10267: END IF;
10268: --
10269: SELECT 'Y'
10270: INTO l_po_line_is_consistent_flag
10271: FROM po_lines
10272: WHERE item_id = p_invoice_lines_rec.inventory_item_id
10273: AND vendor_product_num = p_invoice_lines_rec.vendor_item_num
10274: AND po_header_id = l_po_header_id;
10275: EXCEPTION

Line 10349: FROM po_lines pl

10345: IF l_po_line_location_id IS NOT NULL
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

Line 10360: FROM po_lines

10356:
10357: ELSE
10358: SELECT 'Y'
10359: INTO l_po_line_is_consistent_flag
10360: FROM po_lines
10361: WHERE item_id = p_invoice_lines_rec.inventory_item_id
10362: AND item_description like p_invoice_lines_rec.item_description
10363: AND po_header_id = l_po_header_id;
10364: END IF;

Line 10434: FROM po_lines

10430: --
10431: --
10432: SELECT 'Y'
10433: INTO l_po_line_is_consistent_flag
10434: FROM po_lines
10435: WHERE item_id = p_invoice_lines_rec.inventory_item_id
10436: AND po_line_id = l_po_line_id;
10437: EXCEPTION
10438: WHEN NO_DATA_FOUND THEN

Line 10480: FROM po_lines

10476:
10477: --
10478: SELECT 'Y'
10479: INTO l_po_line_is_consistent_flag
10480: FROM po_lines
10481: WHERE vendor_product_num = p_invoice_lines_rec.vendor_item_num
10482: AND po_line_id = l_po_line_id;
10483: EXCEPTION
10484: WHEN NO_DATA_FOUND THEN

Line 10534: FROM po_lines pl

10530:
10531: --
10532: SELECT 'Y'
10533: INTO l_po_line_is_consistent_flag
10534: FROM po_lines pl
10535: WHERE pl.line_num = p_invoice_lines_rec.po_line_number
10536: AND vendor_product_num = p_invoice_lines_rec.vendor_item_num
10537: AND pl.po_header_id = l_po_header_id;
10538: EXCEPTION

Line 10589: FROM po_lines pl

10585:
10586: --
10587: SELECT 'Y'
10588: INTO l_po_line_is_consistent_flag
10589: FROM po_lines pl
10590: WHERE pl.line_num = p_invoice_lines_rec.po_line_number
10591: -- Bug 6734046 changed vendor_product_num to item_id
10592: AND pl.item_id = p_invoice_lines_rec.inventory_item_id
10593: AND pl.po_header_id = l_po_header_id;

Line 10641: FROM po_lines_trx_v pltv,

10637: END IF;
10638:
10639: SELECT 'Y'
10640: INTO l_po_line_is_consistent_flag
10641: FROM po_lines_trx_v pltv,
10642: po_lines pl
10643: WHERE pl.line_num = p_invoice_lines_rec.po_line_number
10644: AND pl.po_line_id = pltv.po_line_id
10645: AND pl.po_header_id = l_po_header_id;

Line 10642: po_lines pl

10638:
10639: SELECT 'Y'
10640: INTO l_po_line_is_consistent_flag
10641: FROM po_lines_trx_v pltv,
10642: po_lines pl
10643: WHERE pl.line_num = p_invoice_lines_rec.po_line_number
10644: AND pl.po_line_id = pltv.po_line_id
10645: AND pl.po_header_id = l_po_header_id;
10646: EXCEPTION

Line 10681: FROM po_lines_trx_v

10677: END IF;
10678:
10679: SELECT 'Y'
10680: INTO l_po_line_is_consistent_flag
10681: FROM po_lines_trx_v
10682: WHERE po_line_id = l_po_line_id
10683: AND po_header_id = l_po_header_id;
10684: EXCEPTION
10685: WHEN NO_DATA_FOUND THEN

Line 11539: po_lines pl

11535: ph.segment1
11536: INTO l_po_header_id,
11537: l_po_number
11538: FROM po_headers ph,
11539: po_lines pl
11540: WHERE pl.po_line_id = l_po_line_id
11541: AND pl.po_header_id = ph.po_header_id;
11542:
11543: EXCEPTION

Line 11766: FROM po_lines

11762: END IF;
11763:
11764: SELECT po_line_id
11765: INTO l_po_line_id
11766: FROM po_lines
11767: WHERE po_header_id = l_po_header_id;
11768:
11769: EXCEPTION
11770: WHEN NO_DATA_FOUND Then

Line 11774: debug_info := '(v_check_line_po_info 31.4) Too many po lines';

11770: WHEN NO_DATA_FOUND Then
11771: NULL;
11772:
11773: WHEN TOO_MANY_ROWS Then
11774: debug_info := '(v_check_line_po_info 31.4) Too many po lines';
11775: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
11776: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
11777: debug_info);
11778: END IF;

Line 11979: FROM po_lines pl

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
11979: FROM po_lines pl
11980: WHERE pl.po_line_id = l_po_line_id;
11981:
11982: END IF;
11983: --End Bug8546486

Line 13390: FROM po_lines

13386:
13387: BEGIN
13388: SELECT po_line_id
13389: INTO l_po_line_id
13390: FROM po_lines
13391: WHERE po_header_id = l_po_header_id
13392: AND ROWNUM <= 1;
13393: EXCEPTION
13394: when NO_DATA_FOUND then

Line 13859: l_po_line_matching_basis PO_LINES_ALL.MATCHING_BASIS%TYPE;

13855: l_amt_already_billed NUMBER;
13856: l_outstanding NUMBER;
13857: l_ordered NUMBER;
13858: l_already_billed NUMBER;
13859: l_po_line_matching_basis PO_LINES_ALL.MATCHING_BASIS%TYPE;
13860: l_invalid_shipment_type VARCHAR2(1):= '';
13861: l_invalid_shipment_count NUMBER;
13862: l_positive_price_variance NUMBER;
13863: l_total_match_amount NUMBER;

Line 14129: FROM po_lines

14125: --
14126: BEGIN
14127: SELECT allow_price_override_flag
14128: INTO l_price_break
14129: FROM po_lines
14130: WHERE po_line_id = l_po_line_id;
14131:
14132: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
14133: AP_IMPORT_UTILITIES_PKG.Print(

Line 14286: -- Get Unit Price and UOM from PO Lines

14282: END IF;
14283:
14284: -----------------------------------------------------
14285: -- Step 3
14286: -- Get Unit Price and UOM from PO Lines
14287: ------------------------------------------------------
14288: debug_info :=
14289: '(v_check_line_po_info2 3) Get Unit Price / UOM from PO Lines';
14290: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 14289: '(v_check_line_po_info2 3) Get Unit Price / UOM from PO Lines';

14285: -- Step 3
14286: -- Get Unit Price and UOM from PO Lines
14287: ------------------------------------------------------
14288: debug_info :=
14289: '(v_check_line_po_info2 3) Get Unit Price / UOM from PO Lines';
14290: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
14291: AP_IMPORT_UTILITIES_PKG.Print(
14292: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
14293: END IF;

Line 14304: FROM po_lines

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
14304: FROM po_lines
14305: WHERE po_line_id = l_po_line_id;
14306: END IF;*/
14307:
14308: IF (/* Bug 9326135 (p_invoice_lines_rec.quantity_invoiced IS NULL)

Line 14337: FROM po_lines

14333: AND (p_invoice_lines_rec.po_release_id IS NULL) ) THEN
14334:
14335: SELECT unit_price,unit_meas_lookup_code
14336: INTO l_po_unit_price,l_unit_of_measure
14337: FROM po_lines
14338: WHERE po_line_id = l_po_line_id;
14339:
14340: ELSIF ( (p_invoice_lines_rec.quantity_invoiced IS NOT NULL)
14341: AND (l_po_line_id IS NOT NULL)

Line 14356: FROM po_lines

14352: END IF; --Bug6932650
14353:
14354: SELECT unit_meas_lookup_code
14355: INTO l_unit_of_measure
14356: FROM po_lines
14357: WHERE po_line_id = l_po_line_id;
14358:
14359: END IF;
14360: --bug2878889 ends

Line 22383: FROM po_lines_all

22379:
22380: IF (p_invoice_lines_rec.po_line_id IS NOT NULL) THEN
22381: SELECT category_id
22382: INTO l_purchasing_category_id
22383: FROM po_lines_all
22384: WHERE po_line_id = p_invoice_lines_rec.po_line_id;
22385:
22386: ELSE
22387: SELECT pl.category_id

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;