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 370: (SELECT /+ no_unnest index(zf,ZX_LINES_DET_FACTORS_U1) / 'Line Determining Factors Exist'

366: AND entity_code = 'AP_INVOICES')
367: AND NVL(ail.tax_already_calculated_flag, 'N') = 'Y'
368: AND NVL(ail.historical_flag, 'N') = 'N' --bug14671024
369: AND NOT EXISTS
370: (SELECT /*+ no_unnest index(zf,ZX_LINES_DET_FACTORS_U1) */ 'Line Determining Factors Exist'
371: FROM zx_lines_det_factors zf
372: WHERE zf.application_id = 200
373: AND zf.entity_code = 'AP_INVOICES'
374: AND zf.event_class_code IN ('STANDARD INVOICES',

Line 371: FROM zx_lines_det_factors zf

367: AND NVL(ail.tax_already_calculated_flag, 'N') = 'Y'
368: AND NVL(ail.historical_flag, 'N') = 'N' --bug14671024
369: AND NOT EXISTS
370: (SELECT /*+ no_unnest index(zf,ZX_LINES_DET_FACTORS_U1) */ 'Line Determining Factors Exist'
371: FROM zx_lines_det_factors zf
372: WHERE zf.application_id = 200
373: AND zf.entity_code = 'AP_INVOICES'
374: AND zf.event_class_code IN ('STANDARD INVOICES',
375: 'PREPAYMENT INVOICES',

Line 505: from zx_lines_det_factors zf

501: AND nvl(ail.tax_already_calculated_flag, 'N') = 'Y'
502: AND NVL(ail.historical_flag, 'N') = 'N' --bug14671024
503: AND NOT EXISTS
504: (SELECT 'Line Determining Factors Exist'
505: from zx_lines_det_factors zf
506: where zf.application_id = 200
507: and zf.entity_code = 'AP_INVOICES'
508: and zf.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
509: and zf.trx_id = ail.invoice_id

Line 6960: l_intended_use zx_lines_det_factors.line_intended_use%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);
6959:
6960: l_intended_use zx_lines_det_factors.line_intended_use%type;
6961: l_product_type zx_lines_det_factors.product_type%type;
6962: l_product_category zx_lines_det_factors.product_category%type;
6963: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
6964: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;

Line 6961: l_product_type zx_lines_det_factors.product_type%type;

6957: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
6958: l_allow_tax_code_override varchar2(10);
6959:
6960: l_intended_use zx_lines_det_factors.line_intended_use%type;
6961: l_product_type zx_lines_det_factors.product_type%type;
6962: l_product_category zx_lines_det_factors.product_category%type;
6963: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
6964: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
6965: l_assessable_value zx_lines_det_factors.assessable_value%type;

Line 6962: l_product_category zx_lines_det_factors.product_category%type;

6958: l_allow_tax_code_override varchar2(10);
6959:
6960: l_intended_use zx_lines_det_factors.line_intended_use%type;
6961: l_product_type zx_lines_det_factors.product_type%type;
6962: l_product_category zx_lines_det_factors.product_category%type;
6963: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
6964: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
6965: l_assessable_value zx_lines_det_factors.assessable_value%type;
6966:

Line 6963: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;

6959:
6960: l_intended_use zx_lines_det_factors.line_intended_use%type;
6961: l_product_type zx_lines_det_factors.product_type%type;
6962: l_product_category zx_lines_det_factors.product_category%type;
6963: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
6964: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
6965: l_assessable_value zx_lines_det_factors.assessable_value%type;
6966:
6967: l_default_ccid ap_invoice_lines_all.default_dist_ccid%TYPE; --Bug6908977

Line 6964: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;

6960: l_intended_use zx_lines_det_factors.line_intended_use%type;
6961: l_product_type zx_lines_det_factors.product_type%type;
6962: l_product_category zx_lines_det_factors.product_category%type;
6963: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
6964: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
6965: l_assessable_value zx_lines_det_factors.assessable_value%type;
6966:
6967: l_default_ccid ap_invoice_lines_all.default_dist_ccid%TYPE; --Bug6908977
6968:

Line 6965: l_assessable_value zx_lines_det_factors.assessable_value%type;

6961: l_product_type zx_lines_det_factors.product_type%type;
6962: l_product_category zx_lines_det_factors.product_category%type;
6963: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
6964: l_user_defined_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
6965: l_assessable_value zx_lines_det_factors.assessable_value%type;
6966:
6967: l_default_ccid ap_invoice_lines_all.default_dist_ccid%TYPE; --Bug6908977
6968:
6969: l_return_status BOOLEAN := TRUE;

Line 7182: FROM zx_lines_det_factors

7178: ELSE
7179: BEGIN
7180: SELECT 'Y'
7181: INTO l_tax_already_calculated_line
7182: FROM zx_lines_det_factors
7183: WHERE application_id = 200
7184: AND entity_code = 'AP_INVOICES'
7185: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
7186: AND trx_id = l_inv_line_list(i).invoice_id

Line 7458: SELECT /+ index(ZX_LINES_DET_FACTORS ZX_LINES_DET_FACTORS_U1) / -- 9373895

7454:
7455: BEGIN
7456: IF (l_inv_line_list(i).tax_already_calculated_flag = 'Y') THEN
7457:
7458: SELECT /*+ index(ZX_LINES_DET_FACTORS ZX_LINES_DET_FACTORS_U1) */ -- 9373895
7459: line_amt_includes_tax_flag
7460: INTO l_init_line_amt_incl_tax_fg
7461: FROM zx_lines_det_factors
7462: WHERE application_id = 200

Line 7461: FROM zx_lines_det_factors

7457:
7458: SELECT /*+ index(ZX_LINES_DET_FACTORS ZX_LINES_DET_FACTORS_U1) */ -- 9373895
7459: line_amt_includes_tax_flag
7460: INTO l_init_line_amt_incl_tax_fg
7461: FROM zx_lines_det_factors
7462: WHERE application_id = 200
7463: AND entity_code = 'AP_INVOICES'
7464: AND event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
7465: AND trx_id = l_inv_line_list(i).invoice_id

Line 12339: FROM zx_lines_det_factors

12335: product_fisc_classification,
12336: user_defined_fisc_class,
12337: assessable_value,
12338: input_tax_classification_code
12339: FROM zx_lines_det_factors
12340: WHERE application_id = p_application_id
12341: AND internal_organization_id = p_org_id
12342: AND entity_code = p_entity_code
12343: AND event_class_code = p_event_class_code

Line 12416: FROM zx_lines_det_factors

12412: assessable_value,
12413: input_tax_classification_code,
12414: default_taxation_country,
12415: trx_business_category
12416: FROM zx_lines_det_factors
12417: WHERE application_id = p_application_id
12418: AND internal_organization_id = p_org_id
12419: AND entity_code = p_entity_code
12420: AND event_class_code = p_event_class_code

Line 16804: l_intended_use zx_lines_det_factors.line_intended_use%type;

16800: l_ref_doc_trx_id zx_transaction_lines_gt.ref_doc_trx_id%TYPE;
16801:
16802: -- PO Tax Determining Attributes
16803: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
16804: l_intended_use zx_lines_det_factors.line_intended_use%type;
16805: l_product_type zx_lines_det_factors.product_type%type;
16806: l_product_category zx_lines_det_factors.product_category%type;
16807: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
16808: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;

Line 16805: l_product_type zx_lines_det_factors.product_type%type;

16801:
16802: -- PO Tax Determining Attributes
16803: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
16804: l_intended_use zx_lines_det_factors.line_intended_use%type;
16805: l_product_type zx_lines_det_factors.product_type%type;
16806: l_product_category zx_lines_det_factors.product_category%type;
16807: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
16808: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
16809: l_assessable_value zx_lines_det_factors.assessable_value%type;

Line 16806: l_product_category zx_lines_det_factors.product_category%type;

16802: -- PO Tax Determining Attributes
16803: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
16804: l_intended_use zx_lines_det_factors.line_intended_use%type;
16805: l_product_type zx_lines_det_factors.product_type%type;
16806: l_product_category zx_lines_det_factors.product_category%type;
16807: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
16808: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
16809: l_assessable_value zx_lines_det_factors.assessable_value%type;
16810: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;

Line 16807: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;

16803: l_trx_bus_category zx_transaction_lines_gt.trx_business_category%TYPE;
16804: l_intended_use zx_lines_det_factors.line_intended_use%type;
16805: l_product_type zx_lines_det_factors.product_type%type;
16806: l_product_category zx_lines_det_factors.product_category%type;
16807: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
16808: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
16809: l_assessable_value zx_lines_det_factors.assessable_value%type;
16810: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
16811: l_allow_tax_code_override VARCHAR2(10);

Line 16808: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;

16804: l_intended_use zx_lines_det_factors.line_intended_use%type;
16805: l_product_type zx_lines_det_factors.product_type%type;
16806: l_product_category zx_lines_det_factors.product_category%type;
16807: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
16808: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
16809: l_assessable_value zx_lines_det_factors.assessable_value%type;
16810: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
16811: l_allow_tax_code_override VARCHAR2(10);
16812: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269

Line 16809: l_assessable_value zx_lines_det_factors.assessable_value%type;

16805: l_product_type zx_lines_det_factors.product_type%type;
16806: l_product_category zx_lines_det_factors.product_category%type;
16807: l_product_fisc_class zx_lines_det_factors.product_fisc_classification%type;
16808: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
16809: l_assessable_value zx_lines_det_factors.assessable_value%type;
16810: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
16811: l_allow_tax_code_override VARCHAR2(10);
16812: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
16813:

Line 17253: FROM zx_lines_det_factors

17249: AND ROWNUM = 1)
17250: --- Start for bug 6485124
17251: UNION
17252: (SELECT 'Y'
17253: FROM zx_lines_det_factors
17254: WHERE application_id = 200
17255: AND entity_code = 'AP_INVOICES'
17256: AND trx_id = ai.invoice_id
17257: AND event_class_code in ('STANDARD INVOICES','PREPAYMENT INVOICES','EXPENSE REPORTS')