APPS.AP_ETAX_SERVICES_PKG dependencies on ZX_LINES_SUMMARY

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