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 327: po_line_locations pll

323: Select 'Y'
324: Into l_invoice_exists
325: From ap_invoice_distributions aid,
326: po_distributions pd,
327: po_line_locations pll
328: where aid.po_distribution_id = pd.po_distribution_id
329: and pd.line_location_id = pll.line_location_id
330: and pll.line_location_id = l_po_shipment_id
331: and nvl(aid.rcv_transaction_id,-1) =

Line 900: po_line_locations pll,

896: rcv_transactions rtxn,
897: rcv_shipment_headers rsh,
898: rcv_shipment_lines rsl,
899: po_headers ph,
900: po_line_locations pll,
901: po_lines pl,
902: po_vendor_sites pvs
903: WHERE rtxn.transaction_id = p_rcv_txn_id and
904: rtxn.shipment_line_id = rsl.shipment_line_id and