[Home] [Help]
115: ,zl.event_class_code
116: ,zl.trx_line_id
117: ,zl.entity_code
118: FROM po_vendors ven
119: ,ap_invoices inv
120: ,ap_invoice_distributions dis
121: ,zx_rates_b tax
122: ,ap_invoice_distributions item
123: ,ap_invoices pp
119: ,ap_invoices inv
120: ,ap_invoice_distributions dis
121: ,zx_rates_b tax
122: ,ap_invoice_distributions item
123: ,ap_invoices pp
124: ,ap_invoice_distributions ppdis
125: ,ap_checks chk
126: ,ap_invoice_payments aip
127: ,ap_invoice_lines apl
141: AND inv.invoice_id = apl.invoice_id
142: AND apl.invoice_id = zl.trx_id
143: AND apl.line_number = zl.trx_line_number
144: AND apl.application_id = zl.application_id
145: AND zl.entity_code = 'AP_INVOICES'
146: AND inv.invoice_type_lookup_code = zl.event_class_code
147: AND dis.invoice_line_number = apl.line_number
148: AND zl.application_id = zldf.application_id
149: AND zl.event_class_code = zldf.event_class_code
276: AND zx_det.event_class_code = zx_line.event_class_code
277: AND zx_det.trx_id = zx_line.trx_id
278: AND zx_line.trx_id = xla_ent.source_id_int_1 -- Accounting Joins
279: AND zx_det.application_id = xla_ent.application_id
280: AND xla_ent.entity_code = 'AP_INVOICES'
281: AND xla_ent.entity_id = xla_event.entity_id
282: AND xla_event.event_id = xla_head.event_id
283: AND xla_head.ae_header_id = xla_line.ae_header_id
284: AND xla_dist.event_id = xla_event.event_id
330: AND zx_det.event_class_code = zx_line.event_class_code
331: AND zx_det.trx_id = zx_line.trx_id
332: AND zx_line.trx_id = xla_ent.source_id_int_1 -- Accounting Joins
333: AND zx_det.application_id = xla_ent.application_id
334: AND xla_ent.entity_code = 'AP_INVOICES'
335: AND xla_ent.entity_id = xla_event.entity_id
336: AND xla_event.event_id = xla_head.event_id
337: AND xla_head.ae_header_id = xla_line.ae_header_id
338: AND xla_dist.event_id = xla_event.event_id
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,
674: ap_invoice_distributions acctinfo
675: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
681: AND inv.invoice_id = acctinfo.invoice_id
682: AND zl.trx_id = inv.invoice_id
683: AND zl.recoverable_flag = 'Y'
684: AND tax.tax_rate_id = zl.tax_rate_id
685: AND zl.entity_code = 'AP_INVOICES'
686: AND dis.line_type_lookup_code <> 'PREPAY'
687: AND zl.trx_line_dist_id = dis.invoice_distribution_id
688: AND dis.match_status_flag IS NOT NULL
689: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
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,
789: ap_invoice_distributions acctinfo
790: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
796: AND inv.invoice_id = acctinfo.invoice_id
797: AND zl.trx_id = inv.invoice_id
798: AND zl.recoverable_flag = 'Y'
799: AND tax.tax_rate_id = zl.tax_rate_id
800: AND zl.entity_code = 'AP_INVOICES'
801: AND dis.line_type_lookup_code = 'PREPAY'
802: AND zl.trx_line_dist_id = dis.invoice_distribution_id
803: AND dis.match_status_flag IS NOT NULL
804: AND (dis.accounting_date BETWEEN l_start_date AND l_end_date)
886: NULL,
887: decode(aip.reversal_inv_pmt_id,NULL,' ','V'),
888: 'JEFRTXDC'
889: FROM zx_rates_b tax,
890: ap_invoices inv,
891: ap_invoice_distributions dis,
892: po_vendors ven,
893: ap_invoice_payments aip,
894: ap_checks_all chk,
914: AND chk.check_id = aip.check_id
915: AND zl.trx_id = inv.invoice_id
916: AND zl.recoverable_flag = 'Y'
917: AND tax.tax_rate_id = zl.tax_rate_id
918: AND zl.entity_code = 'AP_INVOICES'
919: AND zl.trx_line_dist_id = dis.invoice_distribution_id
920: AND dis.line_type_lookup_code <> 'PREPAY'
921: AND dis.match_status_flag IS NOT NULL
922: AND decode(chk.future_pay_due_date, NULL, aip.accounting_date, decode(sign(aip.accounting_date-chk.future_pay_due_date),1, aip.accounting_date, chk.future_pay_due_date)) BETWEEN l_start_date AND l_end_date
1019: NULL,
1020: 'P',
1021: 'JEFRTXDC'
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,
1040: AND inv.invoice_id = acctinfo.invoice_id
1041: AND zl.trx_id = inv.invoice_id
1042: AND zl.recoverable_flag = 'Y'
1043: AND tax.tax_rate_id = zl.tax_rate_id
1044: AND zl.entity_code = 'AP_INVOICES'
1045: AND zl.trx_line_dist_id = dis.invoice_distribution_id
1046: AND dis.match_status_flag IS NOT NULL
1047: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
1048: AND dis.line_type_lookup_code = 'PREPAY'
1045: AND zl.trx_line_dist_id = dis.invoice_distribution_id
1046: AND dis.match_status_flag IS NOT NULL
1047: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
1048: AND dis.line_type_lookup_code = 'PREPAY'
1049: AND nrec.entity_code = 'AP_INVOICES'
1050: AND nrec.trx_line_dist_id = dis.invoice_distribution_id
1051: AND nrec.trx_id = inv.invoice_id
1052: AND nrec.recoverable_flag = 'N'
1053: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
1117: NULL,
1118: 'P',
1119: 'JEFRTXDC'
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,
1138: AND inv.invoice_id = acctinfo.invoice_id
1139: AND zl.trx_id = inv.invoice_id
1140: AND zl.recoverable_flag = 'Y'
1141: AND tax.tax_rate_id = zl.tax_rate_id
1142: AND zl.entity_code = 'AP_INVOICES'
1143: AND zl.trx_line_dist_id = dis.invoice_distribution_id
1144: AND dis.match_status_flag IS NOT NULL
1145: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
1146: AND dis.line_type_lookup_code = 'PREPAY'
1143: AND zl.trx_line_dist_id = dis.invoice_distribution_id
1144: AND dis.match_status_flag IS NOT NULL
1145: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
1146: AND dis.line_type_lookup_code = 'PREPAY'
1147: AND nrec.entity_code = 'AP_INVOICES'
1148: AND nrec.trx_line_dist_id = dis.invoice_distribution_id
1149: AND nrec.trx_id = inv.invoice_id
1150: AND nrec.recoverable_flag = 'N'
1151: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE
1227: NULL,
1228: 'PP',
1229: 'JEFRTXDC'
1230: FROM zx_rates_b tax,
1231: ap_invoices inv,
1232: ap_invoice_distributions dis,
1233: po_vendors ven,
1234: ap_invoice_distributions pre,
1235: ap_invoice_distributions acctinfo,
1253: AND inv.invoice_id = acctinfo.invoice_id
1254: AND zl.trx_id = inv.invoice_id
1255: AND zl.recoverable_flag = 'Y'
1256: AND tax.tax_rate_id = zl.tax_rate_id
1257: AND zl.entity_code = 'AP_INVOICES'
1258: AND zl.trx_line_dist_id = dis.invoice_distribution_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'
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
1268: AND dis.parent_reversal_id IS NULL
1269: --bug10422464 - start
1808: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1809: FROM ap_invoice_distributions dis
1810: ,zx_rates_b tax
1811: ,ap_invoice_payments aip
1812: ,ap_invoices inv
1813: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1814: AND inv.invoice_id = dis.invoice_id
1815: AND inv.invoice_id = aip.invoice_id
1816: AND dis.invoice_id = p_invoice_id
1826: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1827: FROM ap_invoice_distributions dis
1828: ,zx_rates_b tax
1829: ,ap_invoice_payments aip
1830: ,ap_invoices inv
1831: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1832: AND inv.invoice_id = dis.invoice_id
1833: AND inv.invoice_id = aip.invoice_id
1834: AND dis.invoice_id = p_invoice_id