eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_ETAX_SERVICES_PKG dependencies on AP_INVOICE_LINES_INTERFACE

Line 8156: | existing in the ap_invoice_lines_interface table

Line 8197: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

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;
8200: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
8201:

Line 8245: l_default_ccid AP_INVOICE_LINES_INTERFACE.default_dist_ccid%TYPE; --Bug9841978

8241: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Lines_Import_GT';
8242:
8243: l_copy_line_dff_flag VARCHAR2(1) := 'N'; -- Bug10082937
8244:
8245: l_default_ccid AP_INVOICE_LINES_INTERFACE.default_dist_ccid%TYPE; --Bug9841978
8246:
8247: BEGIN
8248:
8249: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Lines_Import_GT<-' ||

Line 9081: FROM ap_invoice_lines_interface aili

9077: p_inv_line_list(i).line_number, -- summary_tax_line_number
9078: AP_UTILITIES_PKG.ap_round_currency(
9079: p_inv_line_list(i).amount*aili.amount/l_prorating_total,
9080: P_Invoice_Header_Rec.invoice_currency_code) -- line_amt
9081: FROM ap_invoice_lines_interface aili
9082: WHERE aili.invoice_id = P_Invoice_Header_Rec.invoice_id
9083: AND aili.line_number <> p_inv_line_list(i).line_number
9084: AND aili.line_type_lookup_code <> 'TAX'
9085: AND NVL(aili.taxable_flag, 'N') = 'Y';

Line 9112: FROM ap_invoice_lines_interface aili

9108: WHERE trx_id = P_Invoice_Header_Rec.invoice_id
9109: AND trx_line_id <> p_inv_line_list(i).line_number
9110: AND trx_line_id =
9111: (SELECT (MAX(aili.line_number))
9112: FROM ap_invoice_lines_interface aili
9113: WHERE aili.invoice_id = P_Invoice_Header_Rec.invoice_id
9114: AND aili.line_number <> p_inv_line_list(i).line_number
9115: AND aili.amount <> 0
9116: AND aili.line_type_lookup_code <> 'TAX'

Line 9120: FROM ap_invoice_lines_interface ail2

9116: AND aili.line_type_lookup_code <> 'TAX'
9117: AND NVL(aili.taxable_flag, 'N') = 'Y'
9118: AND ABS(aili.amount) >=
9119: ( SELECT MAX(ABS(ail2.amount))
9120: FROM ap_invoice_lines_interface ail2
9121: WHERE ail2.invoice_id = aili.invoice_id
9122: AND ail2.line_number <> p_inv_line_list(i).line_number
9123: AND ail2.line_number <> aili.line_number
9124: AND ail2.line_type_lookup_code <> 'TAX'

Line 9153: FROM ap_invoice_lines_interface

9149: END IF;
9150: --------------------------------------------------------------
9151: SELECT SUM(NVL(amount, 0))
9152: INTO l_prorating_total
9153: FROM ap_invoice_lines_interface
9154: WHERE invoice_id = P_Invoice_Header_Rec.invoice_id
9155: AND line_number <> p_inv_line_list(i).line_number
9156: AND line_type_lookup_code <> 'TAX' --Bug6608702**
9157: AND line_group_number = p_inv_line_list(i).line_group_number;

Line 9186: FROM ap_invoice_lines_interface aili

9182: p_inv_line_list(i).line_number, -- summary_tax_line_number
9183: AP_UTILITIES_PKG.ap_round_currency(
9184: p_inv_line_list(i).amount*aili.amount/l_prorating_total,
9185: P_Invoice_Header_Rec.invoice_currency_code) -- line_amt
9186: FROM ap_invoice_lines_interface aili
9187: WHERE aili.invoice_id = P_Invoice_Header_Rec.invoice_id
9188: AND aili.line_number <> p_inv_line_list(i).line_number
9189: AND aili.line_type_lookup_code <> 'TAX' --Bug6608702**
9190: AND aili.line_group_number = p_inv_line_list(i).line_group_number;

Line 9216: FROM ap_invoice_lines_interface aili

9212: WHERE trx_id = P_Invoice_Header_Rec.invoice_id
9213: AND trx_line_id <> p_inv_line_list(i).line_number
9214: AND trx_line_id =
9215: (SELECT (MAX(aili.line_number))
9216: FROM ap_invoice_lines_interface aili
9217: WHERE aili.invoice_id = P_Invoice_Header_Rec.invoice_id
9218: AND aili.line_number <> p_inv_line_list(i).line_number
9219: AND aili.line_type_lookup_code <> 'TAX' --Bug6608702**
9220: AND aili.amount <> 0

Line 9224: FROM ap_invoice_lines_interface ail2

9220: AND aili.amount <> 0
9221: AND aili.line_group_number = p_inv_line_list(i).line_group_number
9222: AND ABS(aili.amount) >=
9223: ( SELECT MAX(ABS(ail2.amount))
9224: FROM ap_invoice_lines_interface ail2
9225: WHERE ail2.invoice_id = aili.invoice_id
9226: AND ail2.line_number <> p_inv_line_list(i).line_number
9227: AND ail2.line_number <> aili.line_number
9228: AND ail2.line_type_lookup_code <> 'TAX' --Bug6608702**

Line 10047: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%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
10049:
10050: k INT := 1;
10051: l_pseudo INT := 1;

Line 16783: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

16779: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
16780: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
16781: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
16782:
16783: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
16784:
16785: -- Purchase Order
16786: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
16787: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;