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 8579: FROM po_lines

8575: END IF;
8576: --
8577: SELECT 'Y'
8578: INTO l_po_line_is_valid_flag
8579: FROM po_lines
8580: WHERE po_line_id = l_po_line_id;
8581: EXCEPTION
8582: WHEN NO_DATA_FOUND THEN
8583: -- po line id is invalid

Line 8621: FROM po_lines

8617: --
8618: --
8619: SELECT 'Y', po_line_id
8620: INTO l_po_line_is_valid_flag, l_po_line_id
8621: FROM po_lines
8622: WHERE line_num = p_invoice_lines_rec.po_line_number
8623: AND po_header_id = l_po_header_id;
8624: EXCEPTION
8625: WHEN NO_DATA_FOUND THEN

Line 8663: FROM po_lines

8659: END IF;
8660: --
8661: SELECT 'Y'
8662: INTO l_po_line_is_consistent_flag
8663: FROM po_lines
8664: WHERE line_num = p_invoice_lines_rec.po_line_number
8665: AND po_line_id = l_po_line_id;
8666: EXCEPTION
8667: WHEN NO_DATA_FOUND THEN

Line 8985: from po_lines pol, po_headers poh

8981: INTO l_po_rel_is_consistent_flag
8982: FROM po_line_locations
8983: WHERE po_line_id = (
8984: select po_line_id
8985: from po_lines pol, po_headers poh
8986: where poh.po_header_id = pol.po_header_id
8987: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
8988: -- fix for bug 2809177 commented above line and wrote the below one
8989: and poh.po_header_id = l_po_header_id

Line 9014: from po_lines pol, po_headers poh

9010: INTO l_po_rel_is_consistent_flag
9011: FROM po_line_locations
9012: WHERE po_line_id = (
9013: select po_line_id
9014: from po_lines pol, po_headers poh
9015: where poh.po_header_id = pol.po_header_id
9016: -- and poh.po_header_id = nvl(l_po_header_id, poh.po_header_id)
9017: -- and poh.segment1 = nvl(p_invoice_lines_rec.po_number, poh.segment1)
9018: -- fix for bug 2809177 commented above two lines and wrote the below one

Line 9074: FROM po_lines

9070: END IF;
9071: --
9072: SELECT 'Y', po_line_id
9073: INTO l_po_is_valid_flag, l_po_line_id
9074: FROM po_lines
9075: WHERE item_id = p_invoice_lines_rec.inventory_item_id
9076: AND po_header_id = l_po_header_id;
9077: EXCEPTION
9078: WHEN NO_DATA_FOUND THEN

Line 9141: FROM po_lines

9137: END IF;
9138: --
9139: SELECT 'Y', po_line_id
9140: INTO l_po_is_valid_flag, l_po_line_id
9141: FROM po_lines
9142: WHERE vendor_product_num = p_invoice_lines_rec.vendor_item_num
9143: AND po_header_id = l_po_header_id;
9144: EXCEPTION
9145: WHEN NO_DATA_FOUND THEN

Line 9215: FROM po_lines

9211: END IF;
9212: --
9213: SELECT 'Y', po_line_id
9214: INTO l_po_is_valid_flag, l_po_line_id
9215: FROM po_lines
9216: WHERE item_description like p_invoice_lines_rec.item_description
9217: AND po_header_id = l_po_header_id;
9218: EXCEPTION
9219: WHEN NO_DATA_FOUND THEN

Line 9290: FROM po_lines

9286: END IF;
9287: --
9288: SELECT 'Y'
9289: INTO l_po_line_is_consistent_flag
9290: FROM po_lines
9291: WHERE item_id = p_invoice_lines_rec.inventory_item_id
9292: AND vendor_product_num = p_invoice_lines_rec.vendor_item_num
9293: AND po_header_id = l_po_header_id;
9294: EXCEPTION

Line 9365: FROM po_lines

9361: END IF;
9362: --
9363: SELECT 'Y'
9364: INTO l_po_line_is_consistent_flag
9365: FROM po_lines
9366: WHERE item_id = p_invoice_lines_rec.inventory_item_id
9367: AND item_description like p_invoice_lines_rec.item_description
9368: AND po_header_id = l_po_header_id;
9369: EXCEPTION

Line 9437: FROM po_lines

9433: --
9434: --
9435: SELECT 'Y'
9436: INTO l_po_line_is_consistent_flag
9437: FROM po_lines
9438: WHERE item_id = p_invoice_lines_rec.inventory_item_id
9439: AND po_line_id = l_po_line_id;
9440: EXCEPTION
9441: WHEN NO_DATA_FOUND THEN

Line 9483: FROM po_lines

9479:
9480: --
9481: SELECT 'Y'
9482: INTO l_po_line_is_consistent_flag
9483: FROM po_lines
9484: WHERE vendor_product_num = p_invoice_lines_rec.vendor_item_num
9485: AND po_line_id = l_po_line_id;
9486: EXCEPTION
9487: WHEN NO_DATA_FOUND THEN

Line 9537: FROM po_lines pl

9533:
9534: --
9535: SELECT 'Y'
9536: INTO l_po_line_is_consistent_flag
9537: FROM po_lines pl
9538: WHERE pl.line_num = p_invoice_lines_rec.po_line_number
9539: AND vendor_product_num = p_invoice_lines_rec.vendor_item_num
9540: AND pl.po_header_id = l_po_header_id;
9541: EXCEPTION

Line 9592: FROM po_lines pl

9588:
9589: --
9590: SELECT 'Y'
9591: INTO l_po_line_is_consistent_flag
9592: FROM po_lines pl
9593: WHERE pl.line_num = p_invoice_lines_rec.po_line_number
9594: -- Bug 6734046 changed vendor_product_num to item_id
9595: AND pl.item_id = p_invoice_lines_rec.inventory_item_id
9596: AND pl.po_header_id = l_po_header_id;

Line 10450: po_lines pl

10446: ph.segment1
10447: INTO l_po_header_id,
10448: l_po_number
10449: FROM po_headers ph,
10450: po_lines pl
10451: WHERE pl.po_line_id = l_po_line_id
10452: AND pl.po_header_id = ph.po_header_id;
10453:
10454: EXCEPTION

Line 10677: FROM po_lines

10673: END IF;
10674:
10675: SELECT po_line_id
10676: INTO l_po_line_id
10677: FROM po_lines
10678: WHERE po_header_id = l_po_header_id;
10679:
10680: EXCEPTION
10681: WHEN NO_DATA_FOUND Then

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

10681: WHEN NO_DATA_FOUND Then
10682: NULL;
10683:
10684: WHEN TOO_MANY_ROWS Then
10685: debug_info := '(v_check_line_po_info 31.4) Too many po lines';
10686: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
10687: AP_IMPORT_UTILITIES_PKG.Print(AP_IMPORT_INVOICES_PKG.g_debug_switch,
10688: debug_info);
10689: END IF;

Line 12146: FROM po_lines

12142:
12143: BEGIN
12144: SELECT po_line_id
12145: INTO l_po_line_id
12146: FROM po_lines
12147: WHERE po_header_id = l_po_header_id
12148: AND ROWNUM <= 1;
12149: EXCEPTION
12150: when NO_DATA_FOUND then

Line 12507: l_po_line_matching_basis PO_LINES_ALL.MATCHING_BASIS%TYPE;

12503: l_amt_already_billed NUMBER;
12504: l_outstanding NUMBER;
12505: l_ordered NUMBER;
12506: l_already_billed NUMBER;
12507: l_po_line_matching_basis PO_LINES_ALL.MATCHING_BASIS%TYPE;
12508: l_invalid_shipment_type VARCHAR2(1):= '';
12509: l_invalid_shipment_count NUMBER;
12510: l_positive_price_variance NUMBER;
12511: l_total_match_amount NUMBER;

Line 12764: FROM po_lines

12760: --
12761: BEGIN
12762: SELECT allow_price_override_flag
12763: INTO l_price_break
12764: FROM po_lines
12765: WHERE po_line_id = l_po_line_id;
12766:
12767: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') then
12768: AP_IMPORT_UTILITIES_PKG.Print(

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

12918: END IF;
12919:
12920: -----------------------------------------------------
12921: -- Step 3
12922: -- Get Unit Price and UOM from PO Lines
12923: ------------------------------------------------------
12924: debug_info :=
12925: '(v_check_line_po_info2 3) Get Unit Price / UOM from PO Lines';
12926: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

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

12921: -- Step 3
12922: -- Get Unit Price and UOM from PO Lines
12923: ------------------------------------------------------
12924: debug_info :=
12925: '(v_check_line_po_info2 3) Get Unit Price / UOM from PO Lines';
12926: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN
12927: AP_IMPORT_UTILITIES_PKG.Print(
12928: AP_IMPORT_INVOICES_PKG.g_debug_switch,debug_info);
12929: END IF;

Line 12940: FROM po_lines

12936: WHERE pll.line_location_id = l_po_line_location_id;
12937: ELSE
12938: SELECT unit_price,unit_meas_lookup_code
12939: INTO l_po_unit_price,l_unit_of_measure
12940: FROM po_lines
12941: WHERE po_line_id = l_po_line_id;
12942: END IF;*/
12943:
12944: IF ((p_invoice_lines_rec.quantity_invoiced IS NULL)

Line 12973: FROM po_lines

12969: AND (p_invoice_lines_rec.po_release_id IS NULL) ) THEN
12970:
12971: SELECT unit_price,unit_meas_lookup_code
12972: INTO l_po_unit_price,l_unit_of_measure
12973: FROM po_lines
12974: WHERE po_line_id = l_po_line_id;
12975:
12976: ELSIF ( (p_invoice_lines_rec.quantity_invoiced IS NOT NULL)
12977: AND (l_po_line_id IS NOT NULL)

Line 12992: FROM po_lines

12988: END IF; --Bug6932650
12989:
12990: SELECT unit_meas_lookup_code
12991: INTO l_unit_of_measure
12992: FROM po_lines
12993: WHERE po_line_id = l_po_line_id;
12994:
12995: END IF;
12996: --bug2878889 ends

Line 20558: FROM po_lines_all

20554:
20555: IF (p_invoice_lines_rec.po_line_id IS NOT NULL) THEN
20556: SELECT category_id
20557: INTO l_purchasing_category_id
20558: FROM po_lines_all
20559: WHERE po_line_id = p_invoice_lines_rec.po_line_id;
20560:
20561: ELSE
20562: SELECT pl.category_id

Line 20564: FROM po_lines_all pl, po_line_locations_all pll

20560:
20561: ELSE
20562: SELECT pl.category_id
20563: INTO l_purchasing_category_id
20564: FROM po_lines_all pl, po_line_locations_all pll
20565: WHERE pll.line_location_id = p_invoice_lines_rec.po_line_location_id
20566: AND pl.po_line_id = pll.po_line_id;
20567:
20568: END IF;