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_UTILITY_PKG dependencies on AP_INVOICE_LINES_ALL

Line 876: ap_invoice_lines_all ail

872:
873: CURSOR prepay_awt_group_id (c_prepay_dist_id IN NUMBER) IS
874: SELECT ail.awt_group_id
875: FROM ap_invoice_distributions_all aid,
876: ap_invoice_lines_all ail
877: WHERE aid.invoice_distribution_id = c_prepay_dist_id
878: AND aid.invoice_id = ail.invoice_id
879: AND aid.invoice_line_number = ail.line_number;
880:

Line 881: l_awt_group_id ap_invoice_lines_all.awt_group_id%TYPE;

877: WHERE aid.invoice_distribution_id = c_prepay_dist_id
878: AND aid.invoice_id = ail.invoice_id
879: AND aid.invoice_line_number = ail.line_number;
880:
881: l_awt_group_id ap_invoice_lines_all.awt_group_id%TYPE;
882:
883: BEGIN
884:
885: l_curr_calling_sequence := 'AP_ETAX_UTILITY_PKG.Get_Prepay_Awt_Group_Id<-'||

Line 946: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;

942: l_debug_info VARCHAR2(240);
943: l_curr_calling_sequence VARCHAR2(4000);
944:
945: l_period_name gl_period_statuses.period_name%TYPE;
946: l_gl_date ap_invoice_lines_all.accounting_date%TYPE;
947: l_wfapproval_flag ap_system_parameters_all.approval_workflow_flag%TYPE;
948: l_awt_include_tax_amt ap_system_parameters_all.awt_include_tax_amt%TYPE;
949: l_base_currency_code ap_system_parameters_all.base_currency_code%TYPE;
950: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;

Line 954: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;

950: l_combined_filing_flag ap_system_parameters_all.combined_filing_flag%TYPE;
951: l_income_tax_region_flag ap_system_parameters_all.income_tax_region_flag%TYPE;
952: l_income_tax_region ap_system_parameters_all.income_tax_region%TYPE;
953: l_disc_is_inv_less_tax_flag ap_system_parameters_all.disc_is_inv_less_tax_flag%TYPE;
954: l_wfapproval_status ap_invoice_lines_all.wfapproval_status%TYPE;
955: l_new_amt_applicable_to_disc ap_invoices_all.amount_applicable_to_discount%TYPE;
956: l_payment_priority ap_batches_all.payment_priority%TYPE;
957:
958: l_total_tax_amount NUMBER;

Line 964: From ap_invoice_lines_all ail

960:
961: -- Allocations
962: Cursor c_item_line (c_invoice_id IN NUMBER) IS
963: Select ail.line_number
964: From ap_invoice_lines_all ail
965: Where ail.invoice_id = c_invoice_id
966: And ail.line_type_lookup_code = 'TAX'
967: And ail.prepay_invoice_id IS NULL;
968:

Line 1002: FROM AP_INVOICE_LINES_ALL ail

998: l_ap_summary_tax_line_id := NULL;
999:
1000: SELECT ail.line_number, ail.summary_tax_line_id
1001: INTO l_invoice_line_number, l_ap_summary_tax_line_id
1002: FROM AP_INVOICE_LINES_ALL ail
1003: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1004: AND ail.line_type_lookup_code = 'TAX'
1005: AND NOT EXISTS
1006: (SELECT ls.summary_tax_line_id

Line 1121: UPDATE ap_invoice_lines_all ail

1117: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1118: END IF;
1119: -------------------------------------------------------------------
1120: BEGIN
1121: UPDATE ap_invoice_lines_all ail
1122: SET
1123: (ail.description,
1124: ail.amount,
1125: ail.base_amount,

Line 1189: /* Start for bug 5943074-- updating summary_tax_line_id of ap_invoice_lines_all based on zx_lines

1185:
1186: APP_EXCEPTION.RAISE_EXCEPTION;
1187: END;
1188:
1189: /* Start for bug 5943074-- updating summary_tax_line_id of ap_invoice_lines_all based on zx_lines
1190: for manual tax lines and tax only lines so that we do not delete and regenerate the tax lines . */
1191: -------------------------------------------------------------------
1192: l_debug_info := 'Update summary tax line id for manual tax lines';
1193: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1199: UPDATE ap_invoice_lines_all ail

1195: END IF;
1196: -------------------------------------------------------------------
1197: BEGIN
1198:
1199: UPDATE ap_invoice_lines_all ail
1200: SET ail.summary_tax_line_id = (SELECT zl.summary_tax_line_id
1201: FROM zx_lines zl
1202: WHERE zl.application_id = 200
1203: AND zl.entity_code = 'AP_INVOICES'

Line 1224: FROM ap_invoice_lines_all ail2

1220: AND ail.line_source in ('MANUAL LINE ENTRY','IMPORTED')
1221: AND ail.summary_tax_line_id IS NULL
1222: AND NOT EXISTS
1223: (SELECT 1
1224: FROM ap_invoice_lines_all ail2
1225: WHERE ail2.invoice_id = ail.invoice_id
1226: AND ail2.line_number <> ail.line_number
1227: AND ail2.tax_regime_code = ail.tax_regime_code
1228: AND ail2.tax = ail.tax

Line 1263: DELETE ap_invoice_lines_all ail

1259: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1260: END IF;
1261: -------------------------------------------------------------------
1262: BEGIN
1263: DELETE ap_invoice_lines_all ail
1264: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1265: AND ail.line_type_lookup_code = 'TAX'
1266: AND NOT EXISTS (SELECT ls.summary_tax_line_id
1267: FROM zx_lines_summary ls

Line 1280: FROM ap_invoice_lines_all l

1276: DELETE FROM ap_allocation_rules ar
1277: WHERE ar.invoice_id = p_invoice_header_rec.invoice_id
1278: AND NOT EXISTS
1279: (SELECT 'y'
1280: FROM ap_invoice_lines_all l
1281: WHERE l.invoice_id = ar.invoice_id
1282: AND l.line_number = ar.chrg_invoice_line_number);
1283:
1284: DELETE FROM ap_allocation_rule_lines arl

Line 1288: FROM ap_invoice_lines_all l

1284: DELETE FROM ap_allocation_rule_lines arl
1285: WHERE arl.invoice_id = p_invoice_header_rec.invoice_id
1286: AND NOT EXISTS
1287: (SELECT 'y'
1288: FROM ap_invoice_lines_all l
1289: WHERE l.invoice_id = arl.invoice_id
1290: AND l.line_number = arl.chrg_invoice_line_number);
1291: -- Bug 7260087 ends
1292:

Line 1344: INSERT INTO ap_invoice_lines_all (

1340: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1341: END IF;
1342: -------------------------------------------------------------------
1343: BEGIN
1344: INSERT INTO ap_invoice_lines_all (
1345: invoice_id,
1346: line_number,
1347: line_type_lookup_code,
1348: requester_id,

Line 1513: FROM ap_invoice_lines_all ail2

1509: tax_code_id)
1510: SELECT
1511: P_Invoice_Header_Rec.Invoice_Id, -- invoice_id
1512: (SELECT NVL(MAX(ail2.line_number),0)
1513: FROM ap_invoice_lines_all ail2
1514: WHERE ail2.invoice_id = zls.trx_id) + ROWNUM, -- line_number
1515: 'TAX', -- line_type_lookup_code
1516: null, -- requester_id
1517: zls.tax_regime_code||' - '||zls.tax, -- description

Line 1702: ap_invoice_lines_all prepay

1698: FROM ap_invoices_all ai,
1699: ap_suppliers ap,
1700: ap_supplier_sites_all aps,
1701: zx_lines_summary zls,
1702: ap_invoice_lines_all prepay
1703: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
1704: AND ai.vendor_id = ap.vendor_id
1705: AND ai.vendor_site_id = aps.vendor_site_id
1706: AND zls.application_id = 200

Line 1716: FROM ap_invoice_lines_all il

1712: AND NVL(zls.reporting_only_flag, 'N') = 'N'
1713: AND zls.applied_from_trx_id = prepay.invoice_id(+)
1714: AND zls.applied_from_line_id = prepay.line_number(+)
1715: AND NOT EXISTS (SELECT il.summary_tax_line_id
1716: FROM ap_invoice_lines_all il
1717: WHERE il.invoice_id = ai.invoice_id
1718: AND il.summary_tax_line_id = zls.summary_tax_line_id)
1719: AND EXISTS
1720: (SELECT 'Recoupment Exists'

Line 1758: UPDATE ap_invoice_lines_all ail

1754: END IF;
1755: -------------------------------------------------------------------
1756: BEGIN
1757: --bug 6931461
1758: UPDATE ap_invoice_lines_all ail
1759: SET ail.included_tax_amount =
1760: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
1761: FROM zx_lines zl
1762: WHERE zl.application_id = 200

Line 1889: UPDATE ap_invoice_lines_all ail

1885: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1886: END IF;
1887: -----------------------------------------------------------------
1888: BEGIN
1889: UPDATE ap_invoice_lines_all ail
1890: SET ail.tax_already_calculated_flag = 'Y'
1891: WHERE ail.invoice_id = P_invoice_header_rec.invoice_id
1892: AND ail.line_type_lookup_code NOT IN ('TAX', 'AWT')
1893: AND NVL(ail.tax_already_calculated_flag, 'N') = 'N';

Line 1921: UPDATE ap_invoice_lines_all tax

1917: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1918: END IF;
1919: -----------------------------------------------------------------
1920:
1921: UPDATE ap_invoice_lines_all tax
1922: SET tax.invoice_includes_prepay_flag = 'Y'
1923: WHERE tax.invoice_id = P_Invoice_Header_Rec.Invoice_Id
1924: AND tax.line_type_lookup_code = 'TAX'
1925: AND EXISTS

Line 1927: FROM ap_invoice_lines_all prepay

1923: WHERE tax.invoice_id = P_Invoice_Header_Rec.Invoice_Id
1924: AND tax.line_type_lookup_code = 'TAX'
1925: AND EXISTS
1926: (SELECT 'Prepay App Exists'
1927: FROM ap_invoice_lines_all prepay
1928: WHERE prepay.invoice_id = tax.invoice_id
1929: AND prepay.line_type_lookup_code = 'PREPAY'
1930: AND prepay.prepay_invoice_id = tax.prepay_invoice_id
1931: AND prepay.prepay_line_number = tax.prepay_line_number

Line 2315: ap_invoice_lines_all parent_tax_line,

2311: ap_supplier_sites_all pvs,
2312: ap_system_parameters_all asp,
2313: financials_system_params_all fsp,
2314: po_distributions_all pd,
2315: ap_invoice_lines_all parent_tax_line,
2316: ap_invoice_lines_all parent_item_line,
2317: ap_invoice_distributions_all parent_taxable_dist
2318: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2319: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 2316: ap_invoice_lines_all parent_item_line,

2312: ap_system_parameters_all asp,
2313: financials_system_params_all fsp,
2314: po_distributions_all pd,
2315: ap_invoice_lines_all parent_tax_line,
2316: ap_invoice_lines_all parent_item_line,
2317: ap_invoice_distributions_all parent_taxable_dist
2318: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2319: AND gt.ENTITY_CODE = zd.ENTITY_CODE
2320: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 2628: ap_invoice_lines_all parent_tax_line,

2624: ap_supplier_sites_all pvs,
2625: ap_system_parameters_all asp,
2626: financials_system_params_all fsp,
2627: po_distributions_all pd,
2628: ap_invoice_lines_all parent_tax_line,
2629: ap_invoice_lines_all parent_item_line,
2630: ap_invoice_distributions_all parent_taxable_dist,
2631: ap_line_temp_gt dist
2632: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID

Line 2629: ap_invoice_lines_all parent_item_line,

2625: ap_system_parameters_all asp,
2626: financials_system_params_all fsp,
2627: po_distributions_all pd,
2628: ap_invoice_lines_all parent_tax_line,
2629: ap_invoice_lines_all parent_item_line,
2630: ap_invoice_distributions_all parent_taxable_dist,
2631: ap_line_temp_gt dist
2632: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2633: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 2887: ap_invoice_lines_all parent_tax_line,

2883: ap_supplier_sites_all pvs,
2884: ap_system_parameters_all asp,
2885: financials_system_params_all fsp,
2886: po_distributions_all pd,
2887: ap_invoice_lines_all parent_tax_line,
2888: ap_invoice_lines_all parent_item_line,
2889: ap_invoice_distributions_all parent_taxable_dist
2890: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2891: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 2888: ap_invoice_lines_all parent_item_line,

2884: ap_system_parameters_all asp,
2885: financials_system_params_all fsp,
2886: po_distributions_all pd,
2887: ap_invoice_lines_all parent_tax_line,
2888: ap_invoice_lines_all parent_item_line,
2889: ap_invoice_distributions_all parent_taxable_dist
2890: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
2891: AND gt.ENTITY_CODE = zd.ENTITY_CODE
2892: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 3117: ap_invoice_lines_all parent_tax_line,

3113: ap_supplier_sites_all pvs,
3114: ap_system_parameters_all asp,
3115: financials_system_params_all fsp,
3116: po_distributions_all pd,
3117: ap_invoice_lines_all parent_tax_line,
3118: ap_invoice_lines_all parent_item_line,
3119: ap_invoice_distributions_all parent_taxable_dist
3120: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3121: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 3118: ap_invoice_lines_all parent_item_line,

3114: ap_system_parameters_all asp,
3115: financials_system_params_all fsp,
3116: po_distributions_all pd,
3117: ap_invoice_lines_all parent_tax_line,
3118: ap_invoice_lines_all parent_item_line,
3119: ap_invoice_distributions_all parent_taxable_dist
3120: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3121: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3122: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 3319: ap_invoice_lines_all parent_item_line,

3315: ap_supplier_sites_all pvs,
3316: ap_system_parameters_all asp,
3317: financials_system_params_all fsp,
3318: po_distributions_all pd,
3319: ap_invoice_lines_all parent_item_line,
3320: ap_invoice_distributions_all parent_taxable_dist
3321: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3322: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3323: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 3515: ap_invoice_lines_all parent_tax_line,

3511: ap_supplier_sites_all pvs,
3512: ap_system_parameters_all asp,
3513: financials_system_params_all fsp,
3514: po_distributions_all pd,
3515: ap_invoice_lines_all parent_tax_line,
3516: ap_invoice_lines_all parent_item_line,
3517: ap_invoice_distributions_all parent_taxable_dist
3518: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3519: AND gt.ENTITY_CODE = zd.ENTITY_CODE

Line 3516: ap_invoice_lines_all parent_item_line,

3512: ap_system_parameters_all asp,
3513: financials_system_params_all fsp,
3514: po_distributions_all pd,
3515: ap_invoice_lines_all parent_tax_line,
3516: ap_invoice_lines_all parent_item_line,
3517: ap_invoice_distributions_all parent_taxable_dist
3518: WHERE gt.APPLICATION_ID = zd.APPLICATION_ID
3519: AND gt.ENTITY_CODE = zd.ENTITY_CODE
3520: AND gt.EVENT_CLASS_CODE = zd.EVENT_CLASS_CODE

Line 4790: FROM ap_invoice_lines_all ail

4786: END IF;
4787:
4788: UPDATE ap_invoice_distributions_all aid
4789: SET invoice_line_number = (SELECT line_number
4790: FROM ap_invoice_lines_all ail
4791: WHERE ail.invoice_id = aid.invoice_id
4792: AND ail.summary_tax_line_id = aid.summary_tax_line_id
4793: AND rownum = 1)
4794: WHERE aid.invoice_distribution_id IN

Line 4806: FROM ap_invoice_lines_all al

4802: AND gt.trx_id = dist.invoice_id
4803: AND dist.line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV')
4804: AND dist.invoice_line_number NOT IN
4805: (SELECT line_number
4806: FROM ap_invoice_lines_all al
4807: WHERE al.invoice_id = dist.invoice_id)
4808: );
4809:
4810: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 5150: UPDATE ap_invoice_lines_all ail

5146: l_debug_info := 'Step 1: Get data from zx_detail_tax_lines_gt and '||
5147: 'update amount and base_amount for line(s)';
5148: -------------------------------------------------------------------
5149: BEGIN
5150: UPDATE ap_invoice_lines_all ail
5151: SET (ail.amount, ail.base_amount) =
5152: (SELECT NVL(ail.amount, 0) - SUM(NVL(zdl.tax_amt,0)),
5153: NVL(ail.base_amount,0) - SUM(NVL(zdl.tax_amt_funcl_curr,0))
5154: FROM zx_detail_tax_lines_gt zdl

Line 5322: /* FROM ap_invoice_lines_all

5318: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
5319: AND ROWNUM=1;
5320: --- End for bug 6485124
5321: -- commented for bug 6485124
5322: /* FROM ap_invoice_lines_all
5323: WHERE invoice_id = p_invoice_id
5324: AND line_type_lookup_code <> 'AWT'
5325: AND (tax_already_calculated_flag = 'Y'
5326: OR summary_tax_line_id IS NOT NULL)

Line 5414: FROM ap_invoice_lines_all

5410: 'taxable line in the invoice';
5411: -------------------------------------------------------------------
5412: SELECT 'Y'
5413: INTO l_tax_already_calculated_flag
5414: FROM ap_invoice_lines_all
5415: WHERE invoice_id = p_invoice_id
5416: AND line_type_lookup_code <> 'AWT'
5417: AND (tax_already_calculated_flag = 'Y'
5418: OR summary_tax_line_id IS NOT NULL)

Line 6916: l_product_type ap_invoice_lines_all.product_type%type;

6912: l_tax_effective_date DATE;
6913: l_success BOOLEAN;
6914: l_error_code VARCHAR2(30);
6915: l_event_class_code VARCHAR2(100);
6916: l_product_type ap_invoice_lines_all.product_type%type;
6917:
6918: l_debug_info VARCHAR2(240);
6919: l_curr_calling_sequence VARCHAR2(4000);
6920: