[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
659: -1 * nvl(inv.exchange_rate,1) * inv.cancelled_amount) prt_inv_amt,
660: NULL,
661: decode(dis.parent_reversal_id, NULL,' ','C'),
662: 'JEFRTXDC'
663: FROM zx_rec_nrec_dist zl,
664: zx_rates_b tax,
665: ap_invoices inv,
666: ap_invoice_distributions dis,
667: po_vendors ven,
756: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
757: NULL,
758: 'P',
759: 'JEFRTXDC'
760: FROM zx_rec_nrec_dist zl,
761: zx_rates_b tax,
762: ap_invoices inv,
763: ap_invoice_distributions dis,
764: po_vendors ven,
852: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
853: NULL,
854: decode(aip.reversal_inv_pmt_id,NULL,' ','V'),
855: 'JEFRTXDC'
856: FROM zx_rec_nrec_dist zl,
857: zx_rates_b tax,
858: ap_invoices inv,
859: ap_invoice_distributions dis,
860: po_vendors ven,
961: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
962: NULL,
963: 'P',
964: 'JEFRTXDC'
965: FROM zx_rec_nrec_dist zl,
966: zx_rates_b tax,
967: ap_invoices inv,
968: ap_invoice_distributions dis,
969: po_vendors ven,
966: zx_rates_b tax,
967: ap_invoices inv,
968: ap_invoice_distributions dis,
969: po_vendors ven,
970: zx_rec_nrec_dist nrec,
971: ap_invoice_distributions acctinfo
972: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
973: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
974: OR (P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID AND get_balancing_segment(dis.dist_code_combination_id) = P_COMPANY))
1042: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
1043: NULL,
1044: 'P',
1045: 'JEFRTXDC'
1046: FROM zx_rec_nrec_dist zl,
1047: zx_rates_b tax,
1048: ap_invoices inv,
1049: ap_invoice_distributions dis,
1050: po_vendors ven,
1047: zx_rates_b tax,
1048: ap_invoices inv,
1049: ap_invoice_distributions dis,
1050: po_vendors ven,
1051: zx_rec_nrec_dist nrec,
1052: ap_invoice_distributions acctinfo
1053: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
1054: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
1055: OR (P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID AND get_balancing_segment(dis.dist_code_combination_id) = P_COMPANY))
1138: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
1139: NULL,
1140: 'PP',
1141: 'JEFRTXDC'
1142: FROM zx_rec_nrec_dist zl,
1143: zx_rates_b tax,
1144: ap_invoices inv,
1145: ap_invoice_distributions dis,
1146: po_vendors ven,
1166: AND dis.line_type_lookup_code = 'ITEM'
1167: AND dis.match_status_flag IS NOT NULL
1168: AND pre.line_type_lookup_code = 'PREPAY'
1169: AND pre.match_status_flag IS NOT NULL
1170: AND NOT EXISTS ( SELECT 1 FROM zx_rec_nrec_dist zlp where
1171: zlp.trx_id = inv.invoice_id
1172: AND zlp.entity_code = 'AP_INVOICES'
1173: AND zlp.trx_line_dist_id = pre.invoice_distribution_id )
1174: AND pre.accounting_date BETWEEN l_start_date AND l_end_date