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 ZX_LINES

Line 277: FROM zx_lines_det_factors zf

273: AND entity_code = 'AP_INVOICES')
274: AND NVL(ail.tax_already_calculated_flag, 'N') = 'Y'
275: AND NOT EXISTS
276: (SELECT 'Line Determining Factors Exist'
277: FROM zx_lines_det_factors zf
278: WHERE zf.application_id = 200
279: AND zf.entity_code = 'AP_INVOICES'
280: AND zf.event_class_code IN ('STANDARD INVOICES',
281: 'PREPAYMENT INVOICES',

Line 378: from zx_lines_det_factors zf

374: WHERE ail.invoice_id = p_invoice_id
375: AND nvl(ail.tax_already_calculated_flag, 'N') = 'Y'
376: AND NOT EXISTS
377: (SELECT 'Line Determining Factors Exist'
378: from zx_lines_det_factors zf
379: where zf.application_id = 200
380: and zf.entity_code = 'AP_INVOICES'
381: and zf.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
382: and zf.trx_id = ail.invoice_id

Line 2592: FROM zx_lines_summary zls

2588: zls.global_attribute17,
2589: zls.global_attribute18,
2590: zls.global_attribute19,
2591: zls.global_attribute20
2592: FROM zx_lines_summary zls
2593: WHERE zls.summary_tax_line_id = ail.summary_tax_line_id
2594: AND nvl(zls.reporting_only_flag, 'N') = 'N'
2595: )
2596: WHERE ail.invoice_id = P_Invoice_Id

Line 2599: FROM zx_lines_summary ls

2595: )
2596: WHERE ail.invoice_id = P_Invoice_Id
2597: AND ail.line_type_lookup_code = 'TAX'
2598: AND EXISTS (SELECT ls.summary_tax_line_id
2599: FROM zx_lines_summary ls
2600: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
2601: AND ls.trx_id = ail.invoice_id
2602: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
2603: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 2837: FROM zx_lines_summary zls

2833: 0)),
2834: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
2835: 'Y', NVL(zls.tax_amt, 0),
2836: 0))
2837: FROM zx_lines_summary zls
2838: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
2839: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
2840: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
2841: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 4161: from zx_lines_summary zx

4157: WHERE a.invoice_id = p_invoice_id
4158: AND a.line_type_lookup_code = 'TAX'
4159: AND exists
4160: (select 'Tax Only Line'
4161: from zx_lines_summary zx
4162: where zx.summary_tax_line_id = a.summary_tax_line_id
4163: and zx.tax_only_line_flag = 'Y');
4164:
4165: END IF;

Line 5948: l_intended_use zx_lines_det_factors.line_intended_use%type;

5944:
5945: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
5946: l_allow_tax_code_override varchar2(10);
5947:
5948: l_intended_use zx_lines_det_factors.line_intended_use%type;
5949: l_product_type zx_lines_det_factors.product_type%type;
5950: l_product_category zx_lines_det_factors.product_category%type;
5951: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
5952: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;

Line 5949: l_product_type zx_lines_det_factors.product_type%type;

5945: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
5946: l_allow_tax_code_override varchar2(10);
5947:
5948: l_intended_use zx_lines_det_factors.line_intended_use%type;
5949: l_product_type zx_lines_det_factors.product_type%type;
5950: l_product_category zx_lines_det_factors.product_category%type;
5951: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
5952: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
5953: l_assessable_value zx_lines_det_factors.assessable_value%type;

Line 5950: l_product_category zx_lines_det_factors.product_category%type;

5946: l_allow_tax_code_override varchar2(10);
5947:
5948: l_intended_use zx_lines_det_factors.line_intended_use%type;
5949: l_product_type zx_lines_det_factors.product_type%type;
5950: l_product_category zx_lines_det_factors.product_category%type;
5951: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
5952: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
5953: l_assessable_value zx_lines_det_factors.assessable_value%type;
5954:

Line 5951: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;

5947:
5948: l_intended_use zx_lines_det_factors.line_intended_use%type;
5949: l_product_type zx_lines_det_factors.product_type%type;
5950: l_product_category zx_lines_det_factors.product_category%type;
5951: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
5952: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
5953: l_assessable_value zx_lines_det_factors.assessable_value%type;
5954:
5955: l_default_ccid ap_invoice_lines_all.default_dist_ccid%TYPE; --Bug6908977

Line 5952: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;

5948: l_intended_use zx_lines_det_factors.line_intended_use%type;
5949: l_product_type zx_lines_det_factors.product_type%type;
5950: l_product_category zx_lines_det_factors.product_category%type;
5951: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
5952: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
5953: l_assessable_value zx_lines_det_factors.assessable_value%type;
5954:
5955: l_default_ccid ap_invoice_lines_all.default_dist_ccid%TYPE; --Bug6908977
5956:

Line 5953: l_assessable_value zx_lines_det_factors.assessable_value%type;

5949: l_product_type zx_lines_det_factors.product_type%type;
5950: l_product_category zx_lines_det_factors.product_category%type;
5951: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
5952: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
5953: l_assessable_value zx_lines_det_factors.assessable_value%type;
5954:
5955: l_default_ccid ap_invoice_lines_all.default_dist_ccid%TYPE; --Bug6908977
5956:
5957: l_return_status BOOLEAN := TRUE;

Line 6063: FROM zx_lines_det_factors

6059: ELSE
6060: BEGIN
6061: SELECT 'Y'
6062: INTO l_tax_already_calculated_line
6063: FROM zx_lines_det_factors
6064: WHERE application_id = 200
6065: AND entity_code = 'AP_INVOICES'
6066: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
6067: AND trx_id = l_inv_line_list(i).invoice_id

Line 6265: FROM zx_lines_det_factors

6261: IF (l_inv_line_list(i).tax_already_calculated_flag = 'Y') THEN
6262:
6263: SELECT line_amt_includes_tax_flag
6264: INTO l_init_line_amt_incl_tax_fg
6265: FROM zx_lines_det_factors
6266: WHERE application_id = 200
6267: AND entity_code = 'AP_INVOICES'
6268: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
6269: AND trx_id = l_inv_line_list(i).invoice_id

Line 9736: FROM zx_lines_det_factors

9732: product_fisc_classification,
9733: user_defined_fisc_class,
9734: assessable_value,
9735: input_tax_classification_code
9736: FROM zx_lines_det_factors
9737: WHERE application_id = p_application_id
9738: AND internal_organization_id = p_org_id
9739: AND entity_code = p_entity_code
9740: AND event_class_code = p_event_class_code

Line 12178: from zx_lines_summary b

12174: IF p_line_number IS NOT NULL THEN
12175:
12176: UPDATE ap_invoice_lines_all a
12177: SET amount = (select nvl(tax_amt, 0)
12178: from zx_lines_summary b
12179: where b.summary_tax_line_id = a.summary_tax_line_id)
12180: WHERE a.invoice_id = p_invoice_id
12181: AND a.line_type_lookup_code = 'TAX'
12182: AND exists

Line 12184: from zx_lines zx

12180: WHERE a.invoice_id = p_invoice_id
12181: AND a.line_type_lookup_code = 'TAX'
12182: AND exists
12183: (select 'Detail Line'
12184: from zx_lines zx
12185: where zx.summary_tax_line_id = a.summary_tax_line_id
12186: and zx.trx_id = p_invoice_id
12187: and zx.trx_line_id = p_line_number);
12188:

Line 12200: FROM zx_lines_summary zls

12196: 0)),
12197: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
12198: 'Y', NVL(zls.tax_amt, 0),
12199: 0))
12200: FROM zx_lines_summary zls
12201: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12202: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12203: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12204: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 12807: FROM zx_lines_summary zls

12803: AND rownum = 1; */
12804:
12805: SELECT 'Tax Only Line Exist'
12806: INTO l_dummy
12807: FROM zx_lines_summary zls
12808: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
12809: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
12810: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
12811: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 13175: l_intended_use zx_lines_det_factors.line_intended_use%type;

13171: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
13172:
13173: -- PO Tax Determining Attributes
13174: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
13175: l_intended_use zx_lines_det_factors.line_intended_use%type;
13176: l_product_type zx_lines_det_factors.product_type%type;
13177: l_product_category zx_lines_det_factors.product_category%type;
13178: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
13179: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;

Line 13176: l_product_type zx_lines_det_factors.product_type%type;

13172:
13173: -- PO Tax Determining Attributes
13174: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
13175: l_intended_use zx_lines_det_factors.line_intended_use%type;
13176: l_product_type zx_lines_det_factors.product_type%type;
13177: l_product_category zx_lines_det_factors.product_category%type;
13178: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
13179: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
13180: l_assessable_value zx_lines_det_factors.assessable_value%type;

Line 13177: l_product_category zx_lines_det_factors.product_category%type;

13173: -- PO Tax Determining Attributes
13174: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
13175: l_intended_use zx_lines_det_factors.line_intended_use%type;
13176: l_product_type zx_lines_det_factors.product_type%type;
13177: l_product_category zx_lines_det_factors.product_category%type;
13178: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
13179: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
13180: l_assessable_value zx_lines_det_factors.assessable_value%type;
13181: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

Line 13178: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;

13174: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
13175: l_intended_use zx_lines_det_factors.line_intended_use%type;
13176: l_product_type zx_lines_det_factors.product_type%type;
13177: l_product_category zx_lines_det_factors.product_category%type;
13178: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
13179: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
13180: l_assessable_value zx_lines_det_factors.assessable_value%type;
13181: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
13182: l_allow_tax_code_override VARCHAR2(10);

Line 13179: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;

13175: l_intended_use zx_lines_det_factors.line_intended_use%type;
13176: l_product_type zx_lines_det_factors.product_type%type;
13177: l_product_category zx_lines_det_factors.product_category%type;
13178: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
13179: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
13180: l_assessable_value zx_lines_det_factors.assessable_value%type;
13181: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
13182: l_allow_tax_code_override VARCHAR2(10);
13183: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269

Line 13180: l_assessable_value zx_lines_det_factors.assessable_value%type;

13176: l_product_type zx_lines_det_factors.product_type%type;
13177: l_product_category zx_lines_det_factors.product_category%type;
13178: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
13179: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
13180: l_assessable_value zx_lines_det_factors.assessable_value%type;
13181: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
13182: l_allow_tax_code_override VARCHAR2(10);
13183: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
13184:

Line 13607: FROM zx_lines_det_factors

13603: AND ROWNUM = 1)
13604: --- Start for bug 6485124
13605: UNION
13606: (SELECT 'Y'
13607: FROM zx_lines_det_factors
13608: WHERE application_id = 200
13609: AND entity_code = 'AP_INVOICES'
13610: AND trx_id = ai.invoice_id
13611: AND event_class_code in ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS')

Line 14300: FROM zx_lines_summary zls

14296: zls.tax_rate_id, -- tax_rate_id
14297: zls.tax_rate_code, -- tax_rate_code
14298: zls.tax_rate, -- tax_rate
14299: DECODE(ail.generate_dists,'D','D','Y') -- generate_dists bug 5460342
14300: FROM zx_lines_summary zls
14301: WHERE zls.summary_tax_line_id = ail.summary_tax_line_id
14302: AND nvl(zls.reporting_only_flag, 'N') = 'N'
14303: )
14304: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id

Line 14308: FROM zx_lines_summary ls

14304: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
14305: AND ail.line_type_lookup_code = 'TAX'
14306: AND EXISTS
14307: (SELECT ls.summary_tax_line_id
14308: FROM zx_lines_summary ls
14309: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
14310: AND ls.trx_id = ail.invoice_id
14311: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
14312: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 14727: zx_lines_summary zls,

14723: null -- tax_code_id
14724: FROM ap_invoices_all ai,
14725: ap_suppliers ap,
14726: ap_supplier_sites_all aps,
14727: zx_lines_summary zls,
14728: ap_invoice_lines_all prepay
14729: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
14730: AND ai.vendor_id = ap.vendor_id
14731: AND ai.vendor_site_id = aps.vendor_site_id

Line 14776: FROM zx_lines_summary ls

14772: DELETE ap_invoice_lines_all ail
14773: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
14774: AND ail.line_type_lookup_code = 'TAX'
14775: AND NOT EXISTS (SELECT ls.summary_tax_line_id
14776: FROM zx_lines_summary ls
14777: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
14778: AND ls.trx_id = ail.invoice_id
14779: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
14780: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 14818: FROM zx_lines_summary zls

14814: 0)),
14815: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
14816: 'Y', NVL(zls.tax_amt, 0),
14817: 0))
14818: FROM zx_lines_summary zls
14819: WHERE zls.application_id = 200
14820: AND zls.entity_code = 'AP_INVOICES'
14821: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14822: AND zls.trx_id = ai.invoice_id