APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_LINE_LOCATIONS_ALL

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 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 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;