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.JL_BR_AP_ASSOCIATE_COLLECTION dependencies on AP_INVOICES_ALL

Line 70: ap_invoices_ALL apinv

66: SELECT apps.invoice_id, apps.payment_num
67: INTO invoice_id_s, payment_num_s
68: FROM ap_payment_schedules_ALL apps,
69: jl_br_ap_collection_docs jlbl,
70: ap_invoices_ALL apinv
71: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
72: apps.org_id = jlbl.org_id AND --bug 14615620
73: apps.org_id = apinv.org_id AND --bug 14615620
74: (( substr( apinv.invoice_num,1,15 ) = jlbl.document_number AND

Line 93: ap_invoices_ALL apinv

89: SELECT apps.invoice_id, apps.payment_num
90: INTO invoice_id_s, payment_num_s
91: FROM ap_payment_schedules_ALL apps,
92: jl_br_ap_collection_docs jlbl,
93: ap_invoices_ALL apinv
94: /* Bug # 635847 / 659227
95: ,
96: po_vendor_sites povs
97: */

Line 123: ap_invoices_ALL apinv

119: SELECT apps.invoice_id, apps.payment_num
120: INTO invoice_id_s, payment_num_s
121: FROM ap_payment_schedules_ALL apps,
122: jl_br_ap_collection_docs jlbl,
123: ap_invoices_ALL apinv
124: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
125: apps.org_id = jlbl.org_id AND --bug 14615620
126: apps.org_id = apinv.org_id AND --bug 14615620
127: (( apinv.vendor_site_id = jlbl.vendor_site_id AND

Line 148: ap_invoices_ALL apinv

144: SELECT apps.invoice_id, apps.payment_num
145: INTO invoice_id_s, payment_num_s
146: FROM ap_payment_schedules_ALL apps,
147: jl_br_ap_collection_docs jlbl,
148: ap_invoices_ALL apinv
149: /* Bug # 635847 / 659227
150: ,
151: po_vendor_sites povs
152: */

Line 180: ap_invoices_ALL apinv

176: SELECT apps.invoice_id, apps.payment_num
177: INTO invoice_id_s, payment_num_s
178: FROM ap_payment_schedules_ALL apps,
179: jl_br_ap_collection_docs jlbl,
180: ap_invoices_ALL apinv
181: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
182: apps.org_id = jlbl.org_id AND --bug 14615620
183: apps.org_id = apinv.org_id AND --bug 14615620
184: (( substr( apinv.invoice_num,1,15 ) = jlbl.document_number AND

Line 205: ap_invoices_ALL apinv

201: SELECT apps.invoice_id, apps.payment_num
202: INTO invoice_id_s, payment_num_s
203: FROM ap_payment_schedules_ALL apps,
204: jl_br_ap_collection_docs jlbl,
205: ap_invoices_ALL apinv
206: /* Bug # 635847 / 659227
207: ,
208: po_vendor_sites povs
209: */

Line 235: ap_invoices_ALL apinv

231: SELECT apps.invoice_id, apps.payment_num
232: INTO invoice_id_s, payment_num_s
233: FROM ap_payment_schedules_ALL apps,
234: jl_br_ap_collection_docs jlbl,
235: ap_invoices_ALL apinv
236: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
237: apps.org_id = jlbl.org_id AND --bug 14615620
238: apps.org_id = apinv.org_id AND --bug 14615620
239: (( substr( apinv.invoice_num,1,15 ) = jlbl.document_number AND

Line 261: ap_invoices_ALL apinv

257: SELECT apps.invoice_id, apps.payment_num
258: INTO invoice_id_s, payment_num_s
259: FROM ap_payment_schedules_ALL apps,
260: jl_br_ap_collection_docs jlbl,
261: ap_invoices_ALL apinv
262: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
263: apps.org_id = jlbl.org_id AND --bug 14615620
264: apps.org_id = apinv.org_id AND --bug 14615620
265: (( substr( apinv.invoice_num,1,15 ) = jlbl.document_number AND

Line 289: ap_invoices_ALL apinv

285: SELECT apps.invoice_id, apps.payment_num
286: INTO invoice_id_s, payment_num_s
287: FROM ap_payment_schedules_ALL apps,
288: jl_br_ap_collection_docs jlbl,
289: ap_invoices_ALL apinv
290: /* Bug # 635847 / 659227
291: ,
292: po_vendor_sites povs
293: */

Line 323: ap_invoices_ALL apinv

319: SELECT apps.invoice_id, apps.payment_num
320: INTO invoice_id_s, payment_num_s
321: FROM ap_payment_schedules_ALL apps,
322: jl_br_ap_collection_docs jlbl,
323: ap_invoices_ALL apinv
324: /* Bug # 635847 / 659227
325: ,
326: po_vendor_sites povs
327: */

Line 360: ap_invoices_ALL apinv

356: SELECT apps.invoice_id, apps.payment_num
357: INTO invoice_id_s, payment_num_s
358: FROM ap_payment_schedules_ALL apps,
359: jl_br_ap_collection_docs jlbl,
360: ap_invoices_ALL apinv
361: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
362: apps.org_id = jlbl.org_id AND --bug 14615620
363: apps.org_id = apinv.org_id AND --bug 14615620
364: (( substr( apinv.invoice_num,1,15 ) = jlbl.document_number AND

Line 389: ap_invoices_ALL apinv

385: SELECT apps.invoice_id, apps.payment_num
386: INTO invoice_id_s, payment_num_s
387: FROM ap_payment_schedules_ALL apps,
388: jl_br_ap_collection_docs jlbl,
389: ap_invoices_ALL apinv
390: /* Bug # 635847 / 659227
391: ,
392: po_vendor_sites povs
393: */

Line 425: ap_invoices_ALL apinv

421: SELECT apps.invoice_id, apps.payment_num
422: INTO invoice_id_s, payment_num_s
423: FROM ap_payment_schedules_ALL apps,
424: jl_br_ap_collection_docs jlbl,
425: ap_invoices_ALL apinv
426: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
427: apps.org_id = jlbl.org_id AND --bug 14615620
428: apps.org_id = apinv.org_id AND --bug 14615620
429: (( substr( apinv.invoice_num,1,15 ) = jlbl.document_number AND

Line 450: ap_invoices_ALL apinv

446: SELECT apps.invoice_id, apps.payment_num
447: INTO invoice_id_s, payment_num_s
448: FROM ap_payment_schedules_ALL apps,
449: jl_br_ap_collection_docs jlbl,
450: ap_invoices_ALL apinv
451: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
452: apps.org_id = jlbl.org_id AND --bug 14615620
453: apps.org_id = apinv.org_id AND --bug 14615620
454: (( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND

Line 481: ap_invoices_ALL apinv

477: SELECT apps.invoice_id, apps.payment_num
478: INTO invoice_id_s, payment_num_s
479: FROM ap_payment_schedules_ALL apps,
480: jl_br_ap_collection_docs jlbl,
481: ap_invoices_ALL apinv
482: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
483: apps.org_id = jlbl.org_id AND --bug 14615620
484: apps.org_id = apinv.org_id AND --bug 14615620
485: (( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND

Line 507: ap_invoices_ALL apinv

503: SELECT apps.invoice_id, apps.payment_num
504: INTO invoice_id_s, payment_num_s
505: FROM ap_payment_schedules_ALL apps,
506: jl_br_ap_collection_docs jlbl,
507: ap_invoices_ALL apinv
508: /* Bug # 635847 / 659227
509: ,
510: po_vendor_sites povs
511: */

Line 732: ap_invoices_ALL apinv

728: SELECT bank_collection_id
729: INTO bank_collection_id_s
730: FROM ap_payment_schedules apps,
731: jl_br_ap_collection_docs_ALL jlbl,
732: ap_invoices_ALL apinv
733: WHERE apps.invoice_id = invoice_id_e AND
734: apps.payment_num = payment_num_e AND
735: apps.org_id = jlbl.org_id AND --bug 14615620
736: apps.org_id = apinv.org_id AND --bug 14615620

Line 755: ap_invoices_ALL apinv

751: SELECT bank_collection_id
752: INTO bank_collection_id_s
753: FROM ap_payment_schedules apps,
754: jl_br_ap_collection_docs_ALL jlbl,
755: ap_invoices_ALL apinv
756: /* Bug # 635847 / 659227
757: ,
758: po_vendor_sites povs
759: */

Line 785: ap_invoices_ALL apinv

781: SELECT bank_collection_id
782: INTO bank_collection_id_s
783: FROM ap_payment_schedules apps,
784: jl_br_ap_collection_docs_ALL jlbl,
785: ap_invoices_ALL apinv
786: WHERE apps.invoice_id = invoice_id_e AND
787: apps.payment_num = payment_num_e AND
788: apps.org_id = jlbl.org_id AND --bug 14615620
789: apps.org_id = apinv.org_id AND --bug 14615620

Line 810: ap_invoices_ALL apinv

806: SELECT bank_collection_id
807: INTO bank_collection_id_s
808: FROM ap_payment_schedules apps,
809: jl_br_ap_collection_docs_ALL jlbl,
810: ap_invoices_ALL apinv
811: /* Bug # 635847 / 659227
812: ,
813: po_vendor_sites povs
814: */

Line 842: ap_invoices_ALL apinv

838: SELECT bank_collection_id
839: INTO bank_collection_id_s
840: FROM ap_payment_schedules apps,
841: jl_br_ap_collection_docs_ALL jlbl,
842: ap_invoices_ALL apinv
843: WHERE apps.invoice_id = invoice_id_e AND
844: apps.payment_num = payment_num_e AND
845: apps.org_id = jlbl.org_id AND --bug 14615620
846: apps.org_id = apinv.org_id AND --bug 14615620

Line 867: ap_invoices_ALL apinv

863: SELECT bank_collection_id
864: INTO bank_collection_id_s
865: FROM ap_payment_schedules apps,
866: jl_br_ap_collection_docs_ALL jlbl,
867: ap_invoices_ALL apinv
868: /* Bug # 635847 / 659227
869: ,
870: po_vendor_sites povs
871: */

Line 897: ap_invoices_ALL apinv

893: SELECT bank_collection_id
894: INTO bank_collection_id_s
895: FROM ap_payment_schedules apps,
896: jl_br_ap_collection_docs_ALL jlbl,
897: ap_invoices_ALL apinv
898: WHERE apps.invoice_id = invoice_id_e AND
899: apps.payment_num = payment_num_e AND
900: apps.org_id = jlbl.org_id AND --bug 14615620
901: apps.org_id = apinv.org_id AND --bug 14615620

Line 923: ap_invoices_ALL apinv

919: SELECT bank_collection_id
920: INTO bank_collection_id_s
921: FROM ap_payment_schedules apps,
922: jl_br_ap_collection_docs_ALL jlbl,
923: ap_invoices_ALL apinv
924: WHERE apps.invoice_id = invoice_id_e AND
925: apps.payment_num = payment_num_e AND
926: apps.org_id = jlbl.org_id AND --bug 14615620
927: apps.org_id = apinv.org_id AND --bug 14615620

Line 951: ap_invoices_ALL apinv

947: SELECT bank_collection_id
948: INTO bank_collection_id_s
949: FROM ap_payment_schedules apps,
950: jl_br_ap_collection_docs_ALL jlbl,
951: ap_invoices_ALL apinv
952: /* Bug # 635847 / 659227
953: ,
954: po_vendor_sites povs
955: */

Line 985: ap_invoices_ALL apinv

981: SELECT bank_collection_id
982: INTO bank_collection_id_s
983: FROM ap_payment_schedules apps,
984: jl_br_ap_collection_docs_ALL jlbl,
985: ap_invoices_ALL apinv
986: /* Bug # 635847 / 659227
987: ,
988: po_vendor_sites povs
989: */

Line 1022: ap_invoices_ALL apinv

1018: SELECT bank_collection_id
1019: INTO bank_collection_id_s
1020: FROM ap_payment_schedules apps,
1021: jl_br_ap_collection_docs_ALL jlbl,
1022: ap_invoices_ALL apinv
1023: WHERE apps.invoice_id = invoice_id_e AND
1024: apps.payment_num = payment_num_e AND
1025: apps.org_id = jlbl.org_id AND --bug 14615620
1026: apps.org_id = apinv.org_id AND --bug 14615620

Line 1051: ap_invoices_ALL apinv

1047: SELECT bank_collection_id
1048: INTO bank_collection_id_s
1049: FROM ap_payment_schedules apps,
1050: jl_br_ap_collection_docs_ALL jlbl,
1051: ap_invoices_ALL apinv
1052: /* Bug # 635847 / 659227
1053: ,
1054: po_vendor_sites povs
1055: */

Line 1087: ap_invoices_ALL apinv

1083: SELECT bank_collection_id
1084: INTO bank_collection_id_s
1085: FROM ap_payment_schedules apps,
1086: jl_br_ap_collection_docs_ALL jlbl,
1087: ap_invoices_ALL apinv
1088: WHERE apps.invoice_id = invoice_id_e AND
1089: apps.payment_num = payment_num_e AND
1090: apps.org_id = jlbl.org_id AND --bug 14615620
1091: apps.org_id = apinv.org_id AND --bug 14615620

Line 1112: ap_invoices_ALL apinv

1108: SELECT bank_collection_id
1109: INTO bank_collection_id_s
1110: FROM ap_payment_schedules apps,
1111: jl_br_ap_collection_docs_ALL jlbl,
1112: ap_invoices_ALL apinv
1113: WHERE apps.invoice_id = invoice_id_e AND
1114: apps.payment_num = payment_num_e AND
1115: apps.org_id = jlbl.org_id AND --bug 14615620
1116: apps.org_id = apinv.org_id AND --bug 14615620

Line 1143: ap_invoices_ALL apinv

1139: SELECT bank_collection_id
1140: INTO bank_collection_id_s
1141: FROM ap_payment_schedules apps,
1142: jl_br_ap_collection_docs_ALL jlbl,
1143: ap_invoices_ALL apinv
1144: WHERE apps.invoice_id = invoice_id_e AND
1145: apps.payment_num = payment_num_e AND
1146: apps.org_id = jlbl.org_id AND --bug 14615620
1147: apps.org_id = apinv.org_id AND --bug 14615620

Line 1169: ap_invoices_ALL apinv

1165: SELECT bank_collection_id
1166: INTO bank_collection_id_s
1167: FROM ap_payment_schedules apps,
1168: jl_br_ap_collection_docs_ALL jlbl,
1169: ap_invoices_ALL apinv
1170: /* Bug # 635847 / 659227
1171: ,
1172: po_vendor_sites povs
1173: */