DBA Data[Home] [Help]

APPS.AP_ETAX_SERVICES_PKG dependencies on PO_VENDOR_SITES_ALL

Line 6954: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

6950: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
6951: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
6952: l_adj_doc_trx_level_type zx_transaction_lines_gt.adjusted_doc_trx_level_type%TYPE;
6953:
6954: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
6955: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
6956:
6957: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
6958: l_allow_tax_code_override varchar2(10);

Line 8195: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

8191: l_line_amt_includes_tax_flag zx_transaction_lines_gt.line_amt_includes_tax_flag%TYPE;
8192:
8193: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
8194: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8195: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
8196:
8197: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
8198: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
8199: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

Line 10044: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

10040: l_adj_doc_event_class_code zx_transaction_lines_gt.adjusted_doc_event_class_code%TYPE;
10041: l_adj_doc_number zx_transaction_lines_gt.adjusted_doc_number%TYPE;
10042: l_adj_doc_date zx_transaction_lines_gt.adjusted_doc_date%TYPE;
10043:
10044: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
10045: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
10046: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
10047: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
10048: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269

Line 11850: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;

11846: l_event_type_code zx_trx_headers_gt.event_type_code%TYPE;
11847:
11848: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
11849: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
11850: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
11851: l_po_line_location_id ap_invoice_lines_all.po_line_location_id%TYPE;
11852:
11853: l_ctrl_hdr_tx_appl_flag zx_transaction_lines_gt.ctrl_hdr_tx_appl_flag%TYPE;
11854: l_line_level_action zx_transaction_lines_gt.line_level_action%TYPE;

Line 16841: l_debug_info := 'Step 2: Get fob_lookup_code from po_vendor_sites_all';

16837: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16838: END IF;
16839: ----------------------------------------------------------------------
16840: ----------------------------------------------------------------------
16841: l_debug_info := 'Step 2: Get fob_lookup_code from po_vendor_sites_all';
16842: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
16843: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16844: END IF;
16845: ----------------------------------------------------------------------

Line 16853: l_debug_info := 'fob_lookup_code from po_vendor_sites_all '||l_fob_point ||'& '||l_location_id||'& '||P_Invoice_Header_Rec.vendor_site_id;

16849: FROM ap_supplier_sites_all
16850: WHERE vendor_site_id = P_Invoice_Header_Rec.vendor_site_id;
16851: END;
16852: ----------------------------------------------------------------------
16853: l_debug_info := 'fob_lookup_code from po_vendor_sites_all '||l_fob_point ||'& '||l_location_id||'& '||P_Invoice_Header_Rec.vendor_site_id;
16854: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
16855: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
16856: END IF;
16857: ----------------------------------------------------------------------