APPS.AP_AUTO_DM_CREATION_PKG dependencies on PO_LINE_LOCATIONS

Line 190: l_po_pay_terms_id po_line_locations.terms_id%TYPE;

186: l_rcv_rate_date rcv_transactions.currency_conversion_date%TYPE;
187: l_rcv_rate_type rcv_transactions.currency_conversion_type%TYPE;
188: l_receipt_num rcv_shipment_headers.receipt_num%TYPE;
189: l_receipt_uom rcv_shipment_lines.unit_of_measure%TYPE;
190: l_po_pay_terms_id po_line_locations.terms_id%TYPE;
191: l_set_of_books_id ap_system_parameters.set_of_books_id%TYPE;
192: l_base_currency_code ap_system_parameters.base_currency_code%TYPE;
193: l_batch_control_flag ap_system_parameters.batch_control_flag%TYPE;
194: l_gl_date_from_rect_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE;

Line 254: l_match_option po_line_locations.match_option%TYPE;

250: l_auto_tax_calc_flag_sys ap_system_parameters.auto_tax_calc_flag%TYPE;
251: l_auto_tax_calc_flag ap_supplier_sites_all.auto_tax_calc_flag%TYPE;
252:
253: --Bug: 2902340
254: l_match_option po_line_locations.match_option%TYPE;
255: l_invoice_exists varchar2(1);
256:
257: --bug:4537655
258: l_match_mode VARCHAR2(25);

Line 320: po_line_locations pll

316: Select 'Y'
317: Into l_invoice_exists
318: From ap_invoice_distributions aid,
319: po_distributions pd,
320: po_line_locations pll
321: where aid.po_distribution_id = pd.po_distribution_id
322: and pd.line_location_id = pll.line_location_id
323: and pll.line_location_id = l_po_shipment_id
324: and nvl(aid.rcv_transaction_id,-1) =

Line 829: po_line_locations pll,

825: rcv_transactions rtxn,
826: rcv_shipment_headers rsh,
827: rcv_shipment_lines rsl,
828: po_headers ph,
829: po_line_locations pll,
830: po_lines pl,
831: po_vendor_sites pvs
832: WHERE rtxn.transaction_id = p_rcv_txn_id and
833: rtxn.shipment_line_id = rsl.shipment_line_id and