[Home] [Help]
258: ,xla_head.period_name
259: ,zx_dist.rec_nrec_tax_dist_id
260: FROM zx_lines zx_line
261: ,zx_lines_det_factors zx_det
262: ,zx_rec_nrec_dist zx_dist
263: ,zx_taxes_vl zx_tax
264: ,zx_rates_vl zx_rate
265: ,xla_transaction_entities xla_ent
266: ,xla_events xla_event
312: ,xla_head.period_name
313: ,zx_dist.rec_nrec_tax_dist_id
314: FROM zx_lines zx_line
315: ,zx_lines_det_factors zx_det
316: ,zx_rec_nrec_dist zx_dist
317: ,zx_taxes_vl zx_tax
318: ,zx_rates_vl zx_rate
319: ,xla_transaction_entities xla_ent
320: ,xla_events xla_event
665: -1 * nvl(inv.exchange_rate,1) * inv.cancelled_amount) prt_inv_amt,
666: NULL,
667: decode(dis.parent_reversal_id, NULL,' ','C'),
668: 'JEFRTXDC'
669: FROM zx_rec_nrec_dist zl,
670: zx_rates_b tax,
671: ap_invoices inv,
672: ap_invoice_distributions dis,
673: po_vendors ven,
780: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
781: NULL,
782: 'P',
783: 'JEFRTXDC'
784: FROM zx_rec_nrec_dist zl,
785: zx_rates_b tax,
786: ap_invoices inv,
787: ap_invoice_distributions dis,
788: po_vendors ven,
892: po_vendors ven,
893: ap_invoice_payments aip,
894: ap_checks_all chk,
895: ap_invoice_distributions acctinfo,
896: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
897: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
898: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
899: AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
900: AND accounts.INTERNAL_ORGANIZATION_ID = zl.INTERNAL_ORGANIZATION_ID
1022: FROM zx_rates_b tax,
1023: ap_invoices inv,
1024: ap_invoice_distributions dis,
1025: po_vendors ven,
1026: zx_rec_nrec_dist nrec,
1027: ap_invoice_distributions acctinfo,
1028: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1029: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
1030: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
1024: ap_invoice_distributions dis,
1025: po_vendors ven,
1026: zx_rec_nrec_dist nrec,
1027: ap_invoice_distributions acctinfo,
1028: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1029: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
1030: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
1031: AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
1032: AND accounts.INTERNAL_ORGANIZATION_ID = zl.INTERNAL_ORGANIZATION_ID
1120: FROM zx_rates_b tax,
1121: ap_invoices inv,
1122: ap_invoice_distributions dis,
1123: po_vendors ven,
1124: zx_rec_nrec_dist nrec,
1125: ap_invoice_distributions acctinfo,
1126: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1127: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
1128: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
1122: ap_invoice_distributions dis,
1123: po_vendors ven,
1124: zx_rec_nrec_dist nrec,
1125: ap_invoice_distributions acctinfo,
1126: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1127: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
1128: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
1129: AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
1130: AND accounts.INTERNAL_ORGANIZATION_ID = zl.INTERNAL_ORGANIZATION_ID
1232: ap_invoice_distributions dis,
1233: po_vendors ven,
1234: ap_invoice_distributions pre,
1235: ap_invoice_distributions acctinfo,
1236: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1237: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
1238: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
1239: AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
1240: AND accounts.INTERNAL_ORGANIZATION_ID = zl.INTERNAL_ORGANIZATION_ID
1259: AND dis.line_type_lookup_code = 'ITEM'
1260: AND dis.match_status_flag IS NOT NULL
1261: AND pre.line_type_lookup_code = 'PREPAY'
1262: AND pre.match_status_flag IS NOT NULL
1263: AND NOT EXISTS ( SELECT 1 FROM zx_rec_nrec_dist zlp where
1264: zlp.trx_id = inv.invoice_id
1265: AND zlp.entity_code = 'AP_INVOICES'
1266: AND zlp.trx_line_dist_id = pre.invoice_distribution_id )
1267: AND pre.accounting_date BETWEEN l_start_date AND l_end_date