APPS.AP_ETAX_UTILITY_PKG dependencies on ZX_LINES_SUMMARY

Line 1007: FROM zx_lines_summary ls

1003: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1004: AND ail.line_type_lookup_code = 'TAX'
1005: AND NOT EXISTS
1006: (SELECT ls.summary_tax_line_id
1007: FROM zx_lines_summary ls
1008: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1009: AND ls.trx_id = ail.invoice_id
1010: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1011: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1027: FROM zx_lines_summary zl

1023: ) --This is done for Mexicana Bug7623255 to avoid such Data Fix Condition
1024: )
1025: AND EXISTS
1026: (SELECT zl.summary_tax_line_id
1027: FROM zx_lines_summary zl
1028: WHERE zl.application_id = 200
1029: AND zl.entity_code = 'AP_INVOICES'
1030: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1031: AND zl.trx_id = ail.invoice_id

Line 1155: FROM zx_lines_summary zls

1151: zls.tax_rate_id, -- tax_rate_id
1152: zls.tax_rate_code, -- tax_rate_code
1153: zls.tax_rate, -- tax_rate
1154: DECODE(ail.generate_dists,'D','D','Y') -- generate_dists bug 5460342
1155: FROM zx_lines_summary zls
1156: WHERE zls.summary_tax_line_id = ail.summary_tax_line_id
1157: AND nvl(zls.reporting_only_flag, 'N') = 'N'
1158: )
1159: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id

Line 1163: FROM zx_lines_summary ls

1159: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1160: AND ail.line_type_lookup_code = 'TAX'
1161: AND EXISTS
1162: (SELECT ls.summary_tax_line_id
1163: FROM zx_lines_summary ls
1164: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1165: AND ls.trx_id = ail.invoice_id
1166: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1167: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1267: FROM zx_lines_summary ls

1263: DELETE ap_invoice_lines_all ail
1264: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1265: AND ail.line_type_lookup_code = 'TAX'
1266: AND NOT EXISTS (SELECT ls.summary_tax_line_id
1267: FROM zx_lines_summary ls
1268: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1269: AND ls.trx_id = ail.invoice_id
1270: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1271: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1701: zx_lines_summary zls,

1697: null -- tax_code_id
1698: FROM ap_invoices_all ai,
1699: ap_suppliers ap,
1700: ap_supplier_sites_all aps,
1701: zx_lines_summary zls,
1702: ap_invoice_lines_all prepay
1703: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
1704: AND ai.vendor_id = ap.vendor_id
1705: AND ai.vendor_site_id = aps.vendor_site_id

Line 1853: FROM zx_lines_summary zls

1849: 0)),
1850: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
1851: 'Y', NVL(zls.tax_amt, 0),
1852: 0))
1853: FROM zx_lines_summary zls
1854: WHERE zls.application_id = 200
1855: AND zls.entity_code = 'AP_INVOICES'
1856: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1857: AND zls.trx_id = ai.invoice_id