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_DET_FACTORS

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 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 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')