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 JL_BR_AP_COLLECTION_DOCS_ALL

Line 731: jl_br_ap_collection_docs_ALL jlbl,

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

Line 754: jl_br_ap_collection_docs_ALL jlbl,

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

Line 784: jl_br_ap_collection_docs_ALL jlbl,

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

Line 809: jl_br_ap_collection_docs_ALL jlbl,

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

Line 841: jl_br_ap_collection_docs_ALL jlbl,

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

Line 866: jl_br_ap_collection_docs_ALL jlbl,

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

Line 896: jl_br_ap_collection_docs_ALL jlbl,

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

Line 922: jl_br_ap_collection_docs_ALL jlbl,

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

Line 950: jl_br_ap_collection_docs_ALL jlbl,

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

Line 984: jl_br_ap_collection_docs_ALL jlbl,

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

Line 1021: jl_br_ap_collection_docs_ALL jlbl,

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

Line 1050: jl_br_ap_collection_docs_ALL jlbl,

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

Line 1086: jl_br_ap_collection_docs_ALL jlbl,

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

Line 1111: jl_br_ap_collection_docs_ALL jlbl,

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

Line 1142: jl_br_ap_collection_docs_ALL jlbl,

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

Line 1168: jl_br_ap_collection_docs_ALL jlbl,

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