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.

[Home] [Help]

APPS.JL_BR_AP_ASSOCIATE_COLLECTION dependencies on JL_BR_AP_COLLECTION_DOCS_ALL

Line 488: jl_br_ap_collection_docs_ALL jlbl,

484: /* Invoice number AND Due date */
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

Line 505: jl_br_ap_collection_docs_ALL jlbl,

501: /* Supplier Site and Supplier Name */
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

Line 529: jl_br_ap_collection_docs_ALL jlbl,

525: BEGIN
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

Line 548: jl_br_ap_collection_docs_ALL jlbl,

544: IF x_selected = 'N' THEN
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

Line 570: jl_br_ap_collection_docs_ALL jlbl,

566: /* Invoice Number AND Due date AND Supplier Site */
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

Line 589: jl_br_ap_collection_docs_ALL jlbl,

585: /* Invoice Number AND Due date AND Supplier Name */
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

Line 613: jl_br_ap_collection_docs_ALL jlbl,

609: /* Invoice number AND Gross Amount AND Due Date */
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

Line 633: jl_br_ap_collection_docs_ALL jlbl,

629: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
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

Line 655: jl_br_ap_collection_docs_ALL jlbl,

651: /* Invoice number AND Gross Amount AND Due Date AND Supplier Name */
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

Line 683: jl_br_ap_collection_docs_ALL jlbl,

679: /* AND Supplier Name */
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

Line 714: jl_br_ap_collection_docs_ALL jlbl,

710: BEGIN
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

Line 737: jl_br_ap_collection_docs_ALL jlbl,

733: IF x_selected = 'N' THEN
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

Line 763: jl_br_ap_collection_docs_ALL jlbl,

759: BEGIN
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

Line 782: jl_br_ap_collection_docs_ALL jlbl,

778: IF x_selected = 'N' THEN
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

Line 803: jl_br_ap_collection_docs_ALL jlbl,

799: /* Gross Amount AND Due Date AND Supplier Site */
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

Line 823: jl_br_ap_collection_docs_ALL jlbl,

819: /* Gross Amount AND Due Date AND Supplier Name */
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