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 77: ( apinv.invoice_type_lookup_code = 'STANDARD') AND

73: apps.org_id = apinv.org_id AND --bug 14615620
74: (( substr( apinv.invoice_num,1,15 ) = jlbl.document_number AND
75: apps.invoice_id = apinv.invoice_id ) AND
76: ( apps.due_date = jlbl.due_date )) AND
77: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
78: ( apps.global_attribute11 IS NULL ) AND
79: ( apinv.cancelled_date IS NULL ) AND
80: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
81: AND apinv.invoice_currency_code = jlbl.currency_code;

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

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

Line 129: ( apinv.invoice_type_lookup_code = 'STANDARD') 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
128: apps.invoice_id = apinv.invoice_id ) ) AND
129: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
130: ( apps.global_attribute11 IS NULL ) AND
131: ( apinv.cancelled_date IS NULL ) AND
132: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
133: AND apinv.invoice_currency_code = jlbl.currency_code;

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

155: apps.org_id = apinv.org_id AND --bug 14615620
156: /* (( povs.vendor_site_id = jlbl.vendor_site_id AND */
157: ((apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND*/
158: apps.invoice_id = apinv.invoice_id ) ) AND
159: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
160: ( apps.global_attribute11 IS NULL ) AND
161: ( apinv.cancelled_date IS NULL ) AND
162: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
163: AND apinv.invoice_currency_code = jlbl.currency_code;

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

185: apps.invoice_id = apinv.invoice_id ) AND
186: ( apps.due_date = jlbl.due_date ) AND
187: ( apinv.vendor_site_id = jlbl.vendor_site_id AND
188: apps.invoice_id = apinv.invoice_id ) ) AND
189: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
190: ( apps.global_attribute11 IS NULL ) AND
191: ( apinv.cancelled_date IS NULL ) AND
192: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
193: AND apinv.invoice_currency_code = jlbl.currency_code;

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

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

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

241: ( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND
242: apinv.invoice_id = apps.invoice_id AND
243: apinv.payment_currency_code = jlbl.currency_code ) AND
244: ( apps.due_date = jlbl.due_date ) ) AND
245: ( apinv.invoice_type_lookup_code = 'STANDARD') AND
246: ( apps.global_attribute11 IS NULL ) AND
247: ( apinv.cancelled_date IS NULL ) AND
248: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
249: AND apinv.invoice_currency_code = jlbl.currency_code;

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

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

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

302: ( apps.due_date = jlbl.due_date ) AND
303: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND*/
304: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND*/
305: apps.invoice_id = apinv.invoice_id ) ) AND
306: ( apinv.invoice_type_lookup_code ='STANDARD') AND
307: ( apps.global_attribute11 IS NULL ) AND
308: ( apinv.cancelled_date IS NULL ) AND
309: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
310: AND apinv.invoice_currency_code = jlbl.currency_code;

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

338: apps.invoice_id = apinv.invoice_id ) AND
339: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND */
340: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND */
341: apps.invoice_id = apinv.invoice_id ) ) AND
342: ( apinv.invoice_type_lookup_code ='STANDARD') AND
343: ( apps.global_attribute11 IS NULL ) AND
344: ( apinv.cancelled_date IS NULL ) AND
345: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
346: AND apinv.invoice_currency_code = jlbl.currency_code;

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

366: ( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND
367: apinv.invoice_id = apps.invoice_id AND
368: apinv.payment_currency_code = jlbl.currency_code ) AND
369: ( apps.due_date = jlbl.due_date ) ) AND
370: ( apinv.invoice_type_lookup_code ='STANDARD') AND
371: ( apps.global_attribute11 IS NULL ) AND
372: ( apinv.cancelled_date IS NULL ) AND
373: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
374: AND apinv.invoice_currency_code = jlbl.currency_code;

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

398: apps.invoice_id = apinv.invoice_id ) AND
399: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND */
400: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND */
401: apps.invoice_id = apinv.invoice_id ) ) AND
402: ( apinv.invoice_type_lookup_code ='STANDARD') AND
403: ( apps.global_attribute11 IS NULL ) AND
404: ( apinv.cancelled_date IS NULL ) AND
405: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
406: AND apinv.invoice_currency_code = jlbl.currency_code;

Line 431: ( apinv.invoice_type_lookup_code ='STANDARD') 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
430: apps.invoice_id = apinv.invoice_id ) ) AND
431: ( apinv.invoice_type_lookup_code ='STANDARD') AND
432: ( apps.global_attribute11 IS NULL ) AND
433: ( apinv.cancelled_date IS NULL ) AND
434: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
435: AND apinv.invoice_currency_code = jlbl.currency_code;

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

456: apinv.payment_currency_code = jlbl.currency_code ) AND
457: ( apps.due_date = jlbl.due_date ) AND
458: ( apinv.vendor_site_id = jlbl.vendor_site_id AND
459: apps.invoice_id = apinv.invoice_id ) ) AND
460: ( apinv.invoice_type_lookup_code ='STANDARD') AND
461: ( apps.global_attribute11 IS NULL ) AND
462: ( apinv.cancelled_date IS NULL ) AND
463: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
464: AND apinv.invoice_currency_code = jlbl.currency_code;

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

487: apinv.payment_currency_code = jlbl.currency_code ) AND
488: ( apps.due_date = jlbl.due_date ) AND
489: ( apinv.vendor_site_id = jlbl.vendor_site_id AND
490: apps.invoice_id = apinv.invoice_id ) ) AND
491: ( apinv.invoice_type_lookup_code ='STANDARD') AND
492: ( apps.global_attribute11 IS NULL ) AND
493: ( apinv.cancelled_date IS NULL ) AND
494: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
495: AND apinv.invoice_currency_code = jlbl.currency_code;

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

518: ( apps.due_date = jlbl.due_date ) AND
519: /* ( povs.vendor_site_id = jlbl.vendor_site_id AND*/
520: ( apinv.vendor_id = jlbl.vendor_id AND /*povs.vendor_id AND*/
521: apps.invoice_id = apinv.invoice_id ) ) AND
522: ( apinv.invoice_type_lookup_code ='STANDARD') AND
523: ( apps.global_attribute11 IS NULL ) AND
524: ( apinv.cancelled_date IS NULL ) AND
525: (nvl(substr(apinv.global_attribute1,1,1),'N') = 'Y')
526: AND apinv.invoice_currency_code = jlbl.currency_code;