DBA Data[Home] [Help]

APPS.AP_AUTO_DM_CREATION_PKG dependencies on PO_LINES

Line 242: l_item_description po_lines.item_description%TYPE;

238: l_amount ap_invoices.invoice_amount%TYPE;
239: l_terms_date DATE;
240: l_pay_curr_invoice_amount ap_invoices.pay_curr_invoice_amount%TYPE;
241: l_pay_cross_rate ap_invoices.payment_cross_rate%TYPE;
242: l_item_description po_lines.item_description%TYPE;
243:
244: debug_info VARCHAR2(2000);
245: curr_calling_sequence VARCHAR2(2000);
246: l_po_dist_id NUMBER ; --Bug fix:1413339

Line 260: l_po_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;

256:
257: --bug:4537655
258: l_match_mode VARCHAR2(25);
259: l_org_id NUMBER;
260: l_po_uom PO_LINES_ALL.UNIT_MEAS_LOOKUP_CODE%TYPE;
261: l_dist_tab AP_MATCHING_PKG.DIST_TAB_TYPE;
262: l_error_code VARCHAR2(4000);
263: l_success BOOLEAN;
264: l_invoice_amount AP_INVOICES_ALL.INVOICE_AMOUNT%TYPE;

Line 830: po_lines pl,

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
834: rsl.shipment_header_id = rsh.shipment_header_id and