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 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 3298: FROM zx_lines_summary zls

3294: zls.global_attribute17,
3295: zls.global_attribute18,
3296: zls.global_attribute19,
3297: zls.global_attribute20
3298: FROM zx_lines_summary zls
3299: WHERE zls.summary_tax_line_id = ail.summary_tax_line_id
3300: AND nvl(zls.reporting_only_flag, 'N') = 'N'
3301: )
3302: WHERE ail.invoice_id = P_Invoice_Id

Line 3305: FROM zx_lines_summary ls

3301: )
3302: WHERE ail.invoice_id = P_Invoice_Id
3303: AND ail.line_type_lookup_code = 'TAX'
3304: AND EXISTS (SELECT ls.summary_tax_line_id
3305: FROM zx_lines_summary ls
3306: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
3307: AND ls.trx_id = ail.invoice_id
3308: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
3309: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 3575: FROM zx_lines_summary zls

3571: 0)),
3572: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
3573: 'Y', NVL(zls.tax_amt, 0),
3574: 0))
3575: FROM zx_lines_summary zls
3576: WHERE zls.application_id = 200
3577: AND zls.entity_code = 'AP_INVOICES'
3578: AND zls.event_class_code IN
3579: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

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 14055: from zx_lines_summary b

14051: cancelled_flag) =
14052: (select NVL(b.tax_amt,0),
14053: NVL(b.tax_amt_funcl_curr,0),
14054: b.cancel_flag
14055: from zx_lines_summary b
14056: where b.application_id = 200
14057: and b.entity_code = 'AP_INVOICES'
14058: and b.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14059: and b.summary_tax_line_id = a.summary_tax_line_id

Line 14065: from zx_lines zx

14061: WHERE a.invoice_id = p_invoice_id
14062: AND a.line_type_lookup_code = 'TAX'
14063: AND exists
14064: (select 'Detail Line'
14065: from zx_lines zx
14066: where zx.application_id = 200
14067: and zx.entity_code = 'AP_INVOICES'
14068: and zx.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14069: and zx.summary_tax_line_id = a.summary_tax_line_id

Line 14082: (SELECT /+ index(ZL ZX_LINES_U1) /SUM(NVL(zl.tax_amt, 0))

14078:
14079: BEGIN
14080: UPDATE ap_invoice_lines_all ail
14081: SET ail.included_tax_amount =
14082: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
14083: FROM zx_lines zl
14084: WHERE zl.application_id = 200
14085: AND zl.entity_code = 'AP_INVOICES'
14086: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

Line 14083: FROM zx_lines zl

14079: BEGIN
14080: UPDATE ap_invoice_lines_all ail
14081: SET ail.included_tax_amount =
14082: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
14083: FROM zx_lines zl
14084: WHERE zl.application_id = 200
14085: AND zl.entity_code = 'AP_INVOICES'
14086: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14087: AND zl.trx_id = ail.invoice_id

Line 14131: from zx_lines_summary b

14127:
14128: UPDATE ap_invoice_lines_all a
14129: SET (amount,base_amount) =
14130: (select nvl(b.tax_amt,0),nvl(b.tax_amt_funcl_curr,0)
14131: from zx_lines_summary b
14132: where b.application_id = 200
14133: and b.entity_code = 'AP_INVOICES'
14134: and b.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14135: and b.trx_id = a.invoice_id

Line 14141: from zx_lines zx

14137: WHERE a.invoice_id = p_invoice_id
14138: AND a.line_type_lookup_code = 'TAX'
14139: AND exists
14140: (select 'Detail Line'
14141: from zx_lines zx
14142: where zx.application_id = 200
14143: and zx.entity_code = 'AP_INVOICES'
14144: and zx.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
14145: and zx.summary_tax_line_id = a.summary_tax_line_id

Line 14164: FROM zx_lines_summary zls

14160: (SELECT SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
14161: 'N', NVL(zls.tax_amt, 0),0)),
14162: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
14163: 'Y', NVL(zls.tax_amt, 0),0))
14164: FROM zx_lines_summary zls
14165: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
14166: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
14167: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
14168: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 16417: FROM zx_lines_summary zls

16413: AND rownum = 1; */
16414:
16415: SELECT 'Tax Only Line Exist'
16416: INTO l_dummy
16417: FROM zx_lines_summary zls
16418: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
16419: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
16420: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
16421: AP_ETAX_PKG.AP_PP_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')

Line 18129: FROM zx_lines_summary zls

18125: zls.tax_rate_id, -- tax_rate_id
18126: zls.tax_rate_code, -- tax_rate_code
18127: zls.tax_rate, -- tax_rate
18128: DECODE(ail.generate_dists,'D','D','Y') -- generate_dists bug 5460342
18129: FROM zx_lines_summary zls
18130: WHERE zls.summary_tax_line_id = ail.summary_tax_line_id
18131: AND nvl(zls.reporting_only_flag, 'N') = 'N'
18132: )
18133: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id

Line 18137: FROM zx_lines_summary ls

18133: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
18134: AND ail.line_type_lookup_code = 'TAX'
18135: AND EXISTS
18136: (SELECT ls.summary_tax_line_id
18137: FROM zx_lines_summary ls
18138: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
18139: AND ls.trx_id = ail.invoice_id
18140: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
18141: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 18558: zx_lines_summary zls,

18554: null -- tax_code_id
18555: FROM ap_invoices_all ai,
18556: ap_suppliers ap,
18557: ap_supplier_sites_all aps,
18558: zx_lines_summary zls,
18559: ap_invoice_lines_all prepay
18560: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
18561: AND ai.vendor_id = ap.vendor_id
18562: AND ai.vendor_site_id = aps.vendor_site_id

Line 18607: FROM zx_lines_summary ls

18603: DELETE ap_invoice_lines_all ail
18604: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
18605: AND ail.line_type_lookup_code = 'TAX'
18606: AND NOT EXISTS (SELECT ls.summary_tax_line_id
18607: FROM zx_lines_summary ls
18608: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
18609: AND ls.trx_id = ail.invoice_id
18610: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
18611: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 18660: FROM zx_lines_summary zls

18656: 0)),
18657: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
18658: 'Y', NVL(zls.tax_amt, 0),
18659: 0))
18660: FROM zx_lines_summary zls
18661: WHERE zls.application_id = 200
18662: AND zls.entity_code = 'AP_INVOICES'
18663: AND zls.event_class_code IN
18664: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')