DBA Data[Home] [Help]

APPS.AP_IMPORT_VALIDATION_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 12516: l_temp_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;

12512: l_temp_match_option VARCHAR2(25);
12513: current_calling_sequence VARCHAR2(2000);
12514: debug_info VARCHAR2(500);
12515: l_line_amount NUMBER; /* Amount Based Matching */
12516: l_temp_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
12517:
12518: BEGIN
12519:
12520: -- Update the calling sequence

Line 14404: l_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;

14400: l_cascade_receipts_flag VARCHAR2(1);
14401: l_price_correct_inv_id AP_INVOICES.INVOICE_ID%TYPE;
14402:
14403: --Contract Payments
14404: l_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
14405:
14406: BEGIN
14407:
14408: -- Update the calling sequence

Line 14686: po_line_locations_all PS ,

14682: INTO l_qty_billed_sum
14683: FROM rcv_transactions RT ,
14684: rcv_shipment_headers SH ,
14685: po_headers_all PH ,
14686: po_line_locations_all PS ,
14687: po_releases_all PR ,
14688: per_all_people_f BU
14689: WHERE RT.po_line_location_id = p_invoice_lines_rec.po_line_location_id
14690: AND SH.receipt_num = nvl(p_invoice_lines_rec.receipt_number,sh.receipt_num)

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;