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 STANDARD

Line 43: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

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
43: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
44: ( apps.global_attribute11 IS NULL ) AND
45: ( apinv.cancelled_date IS NULL ) AND
46: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
47: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 66: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

62: apps.invoice_id = apinv.invoice_id ) AND
63: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND */
64: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND*/
65: apps.invoice_id = apinv.invoice_id ) ) AND
66: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
67: ( apps.global_attribute11 IS NULL ) AND
68: ( apinv.cancelled_date IS NULL ) AND
69: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
70: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 83: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

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
84: ( apps.global_attribute11 IS NULL ) AND
85: ( apinv.cancelled_date IS NULL ) AND
86: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
87: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 107: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

103: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
104: /* (( povs.vendor_site_id = jlbl.vendor_site_id AND */
105: ((apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND*/
106: apps.invoice_id = apinv.invoice_id ) ) AND
107: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
108: ( apps.global_attribute11 IS NULL ) AND
109: ( apinv.cancelled_date IS NULL ) AND
110: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
111: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 127: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

123: apps.invoice_id = apinv.invoice_id ) AND
124: ( apps.due_date = jlbl.due_date ) AND
125: ( apinv.vendor_site_id = jlbl.vendor_site_id AND
126: apps.invoice_id = apinv.invoice_id ) ) AND
127: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
128: ( apps.global_attribute11 IS NULL ) AND
129: ( apinv.cancelled_date IS NULL ) AND
130: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
131: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 151: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

147: ( apps.due_date = jlbl.due_date ) AND
148: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND */
149: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND*/
150: apps.invoice_id = apinv.invoice_id ) ) AND
151: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
152: ( apps.global_attribute11 IS NULL ) AND
153: ( apinv.cancelled_date IS NULL ) AND
154: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
155: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 171: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

167: ( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND
168: apinv.invoice_id = apps.invoice_id AND
169: apinv.payment_currency_code = jlbl.currency_code ) AND
170: ( apps.due_date = jlbl.due_date ) ) AND
171: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
172: ( apps.global_attribute11 IS NULL ) AND
173: ( apinv.cancelled_date IS NULL ) AND
174: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
175: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 193: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

189: apinv.payment_currency_code = jlbl.currency_code ) AND
190: ( apps.due_date = jlbl.due_date ) AND
191: ( apinv.vendor_site_id = jlbl.vendor_site_id AND
192: apps.invoice_id = apinv.invoice_id ) ) AND
193: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
194: ( apps.global_attribute11 IS NULL ) AND
195: ( apinv.cancelled_date IS NULL ) AND
196: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
197: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 220: ( apinv.invoice_type_lookup_code ='STANDARD') AND

216: ( apps.due_date = jlbl.due_date ) AND
217: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND*/
218: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND*/
219: apps.invoice_id = apinv.invoice_id ) ) AND
220: ( apinv.invoice_type_lookup_code ='STANDARD') AND
221: ( apps.global_attribute11 IS NULL ) AND
222: ( apinv.cancelled_date IS NULL ) AND
223: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
224: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 250: ( apinv.invoice_type_lookup_code ='STANDARD') AND

246: apps.invoice_id = apinv.invoice_id ) AND
247: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND */
248: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND */
249: apps.invoice_id = apinv.invoice_id ) ) AND
250: ( apinv.invoice_type_lookup_code ='STANDARD') AND
251: ( apps.global_attribute11 IS NULL ) AND
252: ( apinv.cancelled_date IS NULL ) AND
253: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
254: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 272: ( apinv.invoice_type_lookup_code ='STANDARD') AND

268: ( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND
269: apinv.invoice_id = apps.invoice_id AND
270: apinv.payment_currency_code = jlbl.currency_code ) AND
271: ( apps.due_date = jlbl.due_date ) ) AND
272: ( apinv.invoice_type_lookup_code ='STANDARD') AND
273: ( apps.global_attribute11 IS NULL ) AND
274: ( apinv.cancelled_date IS NULL ) AND
275: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
276: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 298: ( apinv.invoice_type_lookup_code ='STANDARD') AND

294: apps.invoice_id = apinv.invoice_id ) AND
295: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND */
296: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND */
297: apps.invoice_id = apinv.invoice_id ) ) AND
298: ( apinv.invoice_type_lookup_code ='STANDARD') AND
299: ( apps.global_attribute11 IS NULL ) AND
300: ( apinv.cancelled_date IS NULL ) AND
301: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
302: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 317: ( apinv.invoice_type_lookup_code ='STANDARD') AND

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
318: ( apps.global_attribute11 IS NULL ) AND
319: ( apinv.cancelled_date IS NULL ) AND
320: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
321: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 340: ( apinv.invoice_type_lookup_code ='STANDARD') AND

336: apinv.payment_currency_code = jlbl.currency_code ) AND
337: ( apps.due_date = jlbl.due_date ) AND
338: ( apinv.vendor_site_id = jlbl.vendor_site_id AND
339: apps.invoice_id = apinv.invoice_id ) ) AND
340: ( apinv.invoice_type_lookup_code ='STANDARD') AND
341: ( apps.global_attribute11 IS NULL ) AND
342: ( apinv.cancelled_date IS NULL ) AND
343: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
344: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 361: ( apinv.invoice_type_lookup_code ='STANDARD') AND

357: apinv.payment_currency_code = jlbl.currency_code ) AND
358: ( apps.due_date = jlbl.due_date ) AND
359: ( apinv.vendor_site_id = jlbl.vendor_site_id AND
360: apps.invoice_id = apinv.invoice_id ) ) AND
361: ( apinv.invoice_type_lookup_code ='STANDARD') AND
362: ( apps.global_attribute11 IS NULL ) AND
363: ( apinv.cancelled_date IS NULL ) AND
364: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
365: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 386: ( apinv.invoice_type_lookup_code ='STANDARD') AND

382: ( apps.due_date = jlbl.due_date ) AND
383: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND*/
384: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND*/
385: apps.invoice_id = apinv.invoice_id ) ) AND
386: ( apinv.invoice_type_lookup_code ='STANDARD') AND
387: ( apps.global_attribute11 IS NULL ) AND
388: ( apinv.cancelled_date IS NULL ) AND
389: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
390: AND apinv.invoice_currency_code = jlbl.currency_code;