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_SUMMARY

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