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 38: ap_invoices_ALL apinv

34: SELECT apps.invoice_id, apps.payment_num
35: INTO invoice_id_s, payment_num_s
36: FROM ap_payment_schedules_ALL apps,
37: jl_br_ap_collection_docs jlbl,
38: ap_invoices_ALL apinv
39: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
40: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND
41: apps.invoice_id = apinv.invoice_id ) AND
42: ( apps.due_date = jlbl.due_date )) AND

Line 55: ap_invoices_ALL apinv

51: SELECT apps.invoice_id, apps.payment_num
52: INTO invoice_id_s, payment_num_s
53: FROM ap_payment_schedules_ALL apps,
54: jl_br_ap_collection_docs jlbl,
55: ap_invoices_ALL apinv
56: /* Bug # 635847 / 659227
57: ,
58: po_vendor_sites povs
59: */

Line 79: ap_invoices_ALL apinv

75: SELECT apps.invoice_id, apps.payment_num
76: INTO invoice_id_s, payment_num_s
77: FROM ap_payment_schedules_ALL apps,
78: jl_br_ap_collection_docs jlbl,
79: ap_invoices_ALL apinv
80: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
81: (( apinv.vendor_site_id = jlbl.vendor_site_id AND
82: apps.invoice_id = apinv.invoice_id ) ) AND
83: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

Line 98: ap_invoices_ALL apinv

94: SELECT apps.invoice_id, apps.payment_num
95: INTO invoice_id_s, payment_num_s
96: FROM ap_payment_schedules_ALL apps,
97: jl_br_ap_collection_docs jlbl,
98: ap_invoices_ALL apinv
99: /* Bug # 635847 / 659227
100: ,
101: po_vendor_sites povs
102: */

Line 120: ap_invoices_ALL apinv

116: SELECT apps.invoice_id, apps.payment_num
117: INTO invoice_id_s, payment_num_s
118: FROM ap_payment_schedules_ALL apps,
119: jl_br_ap_collection_docs jlbl,
120: ap_invoices_ALL apinv
121: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
122: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND
123: apps.invoice_id = apinv.invoice_id ) AND
124: ( apps.due_date = jlbl.due_date ) AND

Line 139: ap_invoices_ALL apinv

135: SELECT apps.invoice_id, apps.payment_num
136: INTO invoice_id_s, payment_num_s
137: FROM ap_payment_schedules_ALL apps,
138: jl_br_ap_collection_docs jlbl,
139: ap_invoices_ALL apinv
140: /* Bug # 635847 / 659227
141: ,
142: po_vendor_sites povs
143: */

Line 163: ap_invoices_ALL apinv

159: SELECT apps.invoice_id, apps.payment_num
160: INTO invoice_id_s, payment_num_s
161: FROM ap_payment_schedules_ALL apps,
162: jl_br_ap_collection_docs jlbl,
163: ap_invoices_ALL apinv
164: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
165: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND
166: apps.invoice_id = apinv.invoice_id ) AND
167: ( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND

Line 183: ap_invoices_ALL apinv

179: SELECT apps.invoice_id, apps.payment_num
180: INTO invoice_id_s, payment_num_s
181: FROM ap_payment_schedules_ALL apps,
182: jl_br_ap_collection_docs jlbl,
183: ap_invoices_ALL apinv
184: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
185: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND
186: apps.invoice_id = apinv.invoice_id ) AND
187: ( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) 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 233: ap_invoices_ALL apinv

229: SELECT apps.invoice_id, apps.payment_num
230: INTO invoice_id_s, payment_num_s
231: FROM ap_payment_schedules_ALL apps,
232: jl_br_ap_collection_docs jlbl,
233: ap_invoices_ALL apinv
234: /* Bug # 635847 / 659227
235: ,
236: po_vendor_sites povs
237: */

Line 264: ap_invoices_ALL apinv

260: SELECT apps.invoice_id, apps.payment_num
261: INTO invoice_id_s, payment_num_s
262: FROM ap_payment_schedules_ALL apps,
263: jl_br_ap_collection_docs jlbl,
264: ap_invoices_ALL apinv
265: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
266: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND
267: apps.invoice_id = apinv.invoice_id ) AND
268: ( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND

Line 287: ap_invoices_ALL apinv

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

Line 313: ap_invoices_ALL apinv

309: SELECT apps.invoice_id, apps.payment_num
310: INTO invoice_id_s, payment_num_s
311: FROM ap_payment_schedules_ALL apps,
312: jl_br_ap_collection_docs jlbl,
313: ap_invoices_ALL apinv
314: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
315: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND
316: apps.invoice_id = apinv.invoice_id ) ) AND
317: ( apinv.invoice_type_lookup_code ='STANDARD') AND

Line 332: ap_invoices_ALL apinv

328: SELECT apps.invoice_id, apps.payment_num
329: INTO invoice_id_s, payment_num_s
330: FROM ap_payment_schedules_ALL apps,
331: jl_br_ap_collection_docs jlbl,
332: ap_invoices_ALL apinv
333: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
334: (( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND
335: apinv.invoice_id = apps.invoice_id AND
336: apinv.payment_currency_code = jlbl.currency_code ) AND

Line 353: ap_invoices_ALL apinv

349: SELECT apps.invoice_id, apps.payment_num
350: INTO invoice_id_s, payment_num_s
351: FROM ap_payment_schedules_ALL apps,
352: jl_br_ap_collection_docs jlbl,
353: ap_invoices_ALL apinv
354: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
355: (( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND
356: apinv.invoice_id = apps.invoice_id AND
357: apinv.payment_currency_code = jlbl.currency_code ) AND

Line 373: ap_invoices_ALL apinv

369: SELECT apps.invoice_id, apps.payment_num
370: INTO invoice_id_s, payment_num_s
371: FROM ap_payment_schedules_ALL apps,
372: jl_br_ap_collection_docs jlbl,
373: ap_invoices_ALL apinv
374: /* Bug # 635847 / 659227
375: ,
376: po_vendor_sites povs
377: */

Line 489: ap_invoices_ALL apinv

485: SELECT bank_collection_id
486: INTO bank_collection_id_s
487: FROM ap_payment_schedules apps,
488: jl_br_ap_collection_docs_ALL jlbl,
489: ap_invoices_ALL apinv
490: WHERE apps.invoice_id = invoice_id_e AND
491: apps.payment_num = payment_num_e AND
492: (( apinv.invoice_id = apps.invoice_id AND
493: jlbl.document_number = substr( apinv.invoice_num,1,10 )) AND

Line 506: ap_invoices_ALL apinv

502: SELECT bank_collection_id
503: INTO bank_collection_id_s
504: FROM ap_payment_schedules apps,
505: jl_br_ap_collection_docs_ALL jlbl,
506: ap_invoices_ALL apinv
507: /* Bug # 635847 / 659227
508: ,
509: po_vendor_sites povs
510: */

Line 530: ap_invoices_ALL apinv

526: SELECT bank_collection_id
527: INTO bank_collection_id_s
528: FROM ap_payment_schedules apps,
529: jl_br_ap_collection_docs_ALL jlbl,
530: ap_invoices_ALL apinv
531: WHERE apps.invoice_id = invoice_id_e AND
532: apps.payment_num = payment_num_e AND
533: (( apinv.invoice_id = apps.invoice_id AND
534: jlbl.vendor_site_id = apinv.vendor_site_id )) AND

Line 549: ap_invoices_ALL apinv

545: SELECT bank_collection_id
546: INTO bank_collection_id_s
547: FROM ap_payment_schedules apps,
548: jl_br_ap_collection_docs_ALL jlbl,
549: ap_invoices_ALL apinv
550: /* Bug # 635847 / 659227
551: ,
552: po_vendor_sites povs
553: */

Line 571: ap_invoices_ALL apinv

567: SELECT bank_collection_id
568: INTO bank_collection_id_s
569: FROM ap_payment_schedules apps,
570: jl_br_ap_collection_docs_ALL jlbl,
571: ap_invoices_ALL apinv
572: WHERE apps.invoice_id = invoice_id_e AND
573: apps.payment_num = payment_num_e AND
574: (( apinv.invoice_id = apps.invoice_id AND
575: jlbl.document_number = substr( apinv.invoice_num,1,10 ) ) AND

Line 590: ap_invoices_ALL apinv

586: SELECT bank_collection_id
587: INTO bank_collection_id_s
588: FROM ap_payment_schedules apps,
589: jl_br_ap_collection_docs_ALL jlbl,
590: ap_invoices_ALL apinv
591: /* Bug # 635847 / 659227
592: ,
593: po_vendor_sites povs
594: */

Line 614: ap_invoices_ALL apinv

610: SELECT bank_collection_id
611: INTO bank_collection_id_s
612: FROM ap_payment_schedules apps,
613: jl_br_ap_collection_docs_ALL jlbl,
614: ap_invoices_ALL apinv
615: WHERE apps.invoice_id = invoice_id_e AND
616: apps.payment_num = payment_num_e AND
617: (( apinv.invoice_id = apps.invoice_id AND
618: jlbl.document_number = substr( apinv.invoice_num,1,10 ) ) AND

Line 634: ap_invoices_ALL apinv

630: SELECT bank_collection_id
631: INTO bank_collection_id_s
632: FROM ap_payment_schedules apps,
633: jl_br_ap_collection_docs_ALL jlbl,
634: ap_invoices_ALL apinv
635: WHERE apps.invoice_id = invoice_id_e AND
636: apps.payment_num = payment_num_e AND
637: (( apinv.invoice_id = apps.invoice_id AND
638: jlbl.document_number = substr( apinv.invoice_num,1,10 ) ) AND

Line 656: ap_invoices_ALL apinv

652: SELECT bank_collection_id
653: INTO bank_collection_id_s
654: FROM ap_payment_schedules apps,
655: jl_br_ap_collection_docs_ALL jlbl,
656: ap_invoices_ALL apinv
657: /* Bug # 635847 / 659227
658: ,
659: po_vendor_sites povs
660: */

Line 684: ap_invoices_ALL apinv

680: SELECT bank_collection_id
681: INTO bank_collection_id_s
682: FROM ap_payment_schedules apps,
683: jl_br_ap_collection_docs_ALL jlbl,
684: ap_invoices_ALL apinv
685: /* Bug # 635847 / 659227
686: ,
687: po_vendor_sites povs
688: */

Line 715: ap_invoices_ALL apinv

711: SELECT bank_collection_id
712: INTO bank_collection_id_s
713: FROM ap_payment_schedules apps,
714: jl_br_ap_collection_docs_ALL jlbl,
715: ap_invoices_ALL apinv
716: WHERE apps.invoice_id = invoice_id_e AND
717: apps.payment_num = payment_num_e AND
718: (( apinv.invoice_id = apps.invoice_id AND
719: jlbl.document_number = substr( apinv.invoice_num,1,10 ) ) AND

Line 738: ap_invoices_ALL apinv

734: SELECT bank_collection_id
735: INTO bank_collection_id_s
736: FROM ap_payment_schedules apps,
737: jl_br_ap_collection_docs_ALL jlbl,
738: ap_invoices_ALL apinv
739: /* Bug # 635847 / 659227
740: ,
741: po_vendor_sites povs
742: */

Line 764: ap_invoices_ALL apinv

760: SELECT bank_collection_id
761: INTO bank_collection_id_s
762: FROM ap_payment_schedules apps,
763: jl_br_ap_collection_docs_ALL jlbl,
764: ap_invoices_ALL apinv
765: WHERE apps.invoice_id = invoice_id_e AND
766: apps.payment_num = payment_num_e AND
767: (( apinv.invoice_id = apps.invoice_id AND
768: jlbl.document_number = substr( apinv.invoice_num,1,10 ) ) ) AND

Line 783: ap_invoices_ALL apinv

779: SELECT bank_collection_id
780: INTO bank_collection_id_s
781: FROM ap_payment_schedules apps,
782: jl_br_ap_collection_docs_ALL jlbl,
783: ap_invoices_ALL apinv
784: WHERE apps.invoice_id = invoice_id_e AND
785: apps.payment_num = payment_num_e AND
786: (( nvl(jlbl.amount, 0) = nvl(apps.gross_amount, 0) AND
787: apinv.invoice_id = apps.invoice_id AND

Line 804: ap_invoices_ALL apinv

800: SELECT bank_collection_id
801: INTO bank_collection_id_s
802: FROM ap_payment_schedules apps,
803: jl_br_ap_collection_docs_ALL jlbl,
804: ap_invoices_ALL apinv
805: WHERE apps.invoice_id = invoice_id_e AND
806: apps.payment_num = payment_num_e AND
807: (( nvl(jlbl.amount, 0) = nvl(apps.gross_amount, 0) AND
808: apinv.invoice_id = apps.invoice_id AND

Line 824: ap_invoices_ALL apinv

820: SELECT bank_collection_id
821: INTO bank_collection_id_s
822: FROM ap_payment_schedules apps,
823: jl_br_ap_collection_docs_ALL jlbl,
824: ap_invoices_ALL apinv
825: /* Bug # 635847 / 659227
826: ,
827: po_vendor_sites povs
828: */