eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JE_ZZ_AUDIT_AP_PKG dependencies on AP_INVOICES

Line 119: ,ap_invoices inv

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

Line 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

Line 145: AND zl.entity_code = 'AP_INVOICES'

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

Line 280: AND xla_ent.entity_code = 'AP_INVOICES'

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

Line 334: AND xla_ent.entity_code = 'AP_INVOICES'

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

Line 665: ap_invoices inv,

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,
668: ap_invoice_distributions acctinfo
669: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)

Line 679: AND zl.entity_code = 'AP_INVOICES'

675: AND inv.invoice_id = acctinfo.invoice_id
676: AND zl.trx_id = inv.invoice_id
677: AND zl.recoverable_flag = 'Y'
678: AND tax.tax_rate_id = zl.tax_rate_id
679: AND zl.entity_code = 'AP_INVOICES'
680: AND dis.line_type_lookup_code <> 'PREPAY'
681: AND zl.trx_line_dist_id = dis.invoice_distribution_id
682: AND dis.match_status_flag IS NOT NULL
683: AND dis.accounting_date BETWEEN l_start_date AND l_end_date

Line 762: ap_invoices inv,

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,
765: ap_invoice_distributions acctinfo
766: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)

Line 776: AND zl.entity_code = 'AP_INVOICES'

772: AND inv.invoice_id = acctinfo.invoice_id
773: AND zl.trx_id = inv.invoice_id
774: AND zl.recoverable_flag = 'Y'
775: AND tax.tax_rate_id = zl.tax_rate_id
776: AND zl.entity_code = 'AP_INVOICES'
777: AND dis.line_type_lookup_code = 'PREPAY'
778: AND zl.trx_line_dist_id = dis.invoice_distribution_id
779: AND dis.match_status_flag IS NOT NULL
780: AND (dis.accounting_date BETWEEN l_start_date AND l_end_date)

Line 858: ap_invoices inv,

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,
861: ap_invoice_payments aip,
862: ap_checks_all chk,

Line 880: AND zl.entity_code = 'AP_INVOICES'

876: AND chk.check_id = aip.check_id
877: AND zl.trx_id = inv.invoice_id
878: AND zl.recoverable_flag = 'Y'
879: AND tax.tax_rate_id = zl.tax_rate_id
880: AND zl.entity_code = 'AP_INVOICES'
881: AND zl.trx_line_dist_id = dis.invoice_distribution_id
882: AND dis.line_type_lookup_code <> 'PREPAY'
883: AND dis.match_status_flag IS NOT NULL
884: 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

Line 967: ap_invoices inv,

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,
970: zx_rec_nrec_dist nrec,
971: ap_invoice_distributions acctinfo

Line 982: AND zl.entity_code = 'AP_INVOICES'

978: AND inv.invoice_id = acctinfo.invoice_id
979: AND zl.trx_id = inv.invoice_id
980: AND zl.recoverable_flag = 'Y'
981: AND tax.tax_rate_id = zl.tax_rate_id
982: AND zl.entity_code = 'AP_INVOICES'
983: AND zl.trx_line_dist_id = dis.invoice_distribution_id
984: AND dis.match_status_flag IS NOT NULL
985: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
986: AND dis.line_type_lookup_code = 'PREPAY'

Line 987: AND nrec.entity_code = 'AP_INVOICES'

983: AND zl.trx_line_dist_id = dis.invoice_distribution_id
984: AND dis.match_status_flag IS NOT NULL
985: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
986: AND dis.line_type_lookup_code = 'PREPAY'
987: AND nrec.entity_code = 'AP_INVOICES'
988: AND nrec.trx_line_dist_id = dis.invoice_distribution_id
989: AND nrec.trx_id = inv.invoice_id
990: AND nrec.recoverable_flag = 'N'
991: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE

Line 1048: ap_invoices inv,

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,
1051: zx_rec_nrec_dist nrec,
1052: ap_invoice_distributions acctinfo

Line 1063: AND zl.entity_code = 'AP_INVOICES'

1059: AND inv.invoice_id = acctinfo.invoice_id
1060: AND zl.trx_id = inv.invoice_id
1061: AND zl.recoverable_flag = 'Y'
1062: AND tax.tax_rate_id = zl.tax_rate_id
1063: AND zl.entity_code = 'AP_INVOICES'
1064: AND zl.trx_line_dist_id = dis.invoice_distribution_id
1065: AND dis.match_status_flag IS NOT NULL
1066: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
1067: AND dis.line_type_lookup_code = 'PREPAY'

Line 1068: AND nrec.entity_code = 'AP_INVOICES'

1064: AND zl.trx_line_dist_id = dis.invoice_distribution_id
1065: AND dis.match_status_flag IS NOT NULL
1066: AND dis.accounting_date BETWEEN l_start_date AND l_end_date
1067: AND dis.line_type_lookup_code = 'PREPAY'
1068: AND nrec.entity_code = 'AP_INVOICES'
1069: AND nrec.trx_line_dist_id = dis.invoice_distribution_id
1070: AND nrec.trx_id = inv.invoice_id
1071: AND nrec.recoverable_flag = 'N'
1072: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE

Line 1144: ap_invoices inv,

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,
1147: ap_invoice_distributions pre,
1148: ap_invoice_distributions acctinfo

Line 1164: AND zl.entity_code = 'AP_INVOICES'

1160: AND inv.invoice_id = acctinfo.invoice_id
1161: AND zl.trx_id = inv.invoice_id
1162: AND zl.recoverable_flag = 'Y'
1163: AND tax.tax_rate_id = zl.tax_rate_id
1164: AND zl.entity_code = 'AP_INVOICES'
1165: AND zl.trx_line_dist_id = dis.invoice_distribution_id
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'

Line 1172: AND zlp.entity_code = 'AP_INVOICES'

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
1175: AND dis.parent_reversal_id IS NULL
1176: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE

Line 1709: ,ap_invoices inv

1705: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1706: FROM ap_invoice_distributions dis
1707: ,zx_rates_b tax
1708: ,ap_invoice_payments aip
1709: ,ap_invoices inv
1710: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1711: AND inv.invoice_id = dis.invoice_id
1712: AND inv.invoice_id = aip.invoice_id
1713: AND dis.invoice_id = p_invoice_id

Line 1727: ,ap_invoices inv

1723: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1724: FROM ap_invoice_distributions dis
1725: ,zx_rates_b tax
1726: ,ap_invoice_payments aip
1727: ,ap_invoices inv
1728: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1729: AND inv.invoice_id = dis.invoice_id
1730: AND inv.invoice_id = aip.invoice_id
1731: AND dis.invoice_id = p_invoice_id