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.OE_CREDIT_CHECK_LINES_PVT dependencies on OE_PAYMENT_TYPES_ALL

Line 247: FROM oe_payment_types_all pt

243: AND t.credit_check_flag = 'Y'
244: AND (l.ato_line_id IS NULL OR l.ato_line_id = l.line_id)
245: AND (EXISTS
246: (SELECT NULL
247: FROM oe_payment_types_all pt
248: WHERE pt.payment_type_code = NVL(l.payment_type_code,
249: NVL(h.payment_type_code, 'BME'))
250: AND pt.credit_check_flag = 'Y'
251: AND NVL(pt.org_id, -99) = NVL(h.org_id,-99))

Line 280: FROM oe_payment_types_all pt

276: AND t.credit_check_flag = 'Y'
277: AND (l.ato_line_id IS NULL OR l.ato_line_id = l.line_id)
278: AND (EXISTS
279: (SELECT NULL
280: FROM oe_payment_types_all pt
281: WHERE pt.payment_type_code = NVL(l.payment_type_code,
282: NVL(h.payment_type_code, 'BME'))
283: AND pt.credit_check_flag = 'Y'
284: AND NVL(pt.org_id, -99) = NVL(h.org_id,-99))

Line 312: FROM oe_payment_types_all pt

308: AND t.credit_check_flag = 'Y'
309: AND (l.ato_line_id IS NULL OR l.ato_line_id = l.line_id)
310: AND (EXISTS
311: (SELECT NULL
312: FROM oe_payment_types_all pt
313: WHERE pt.payment_type_code = NVL(l.payment_type_code,
314: NVL(h.payment_type_code, 'BME'))
315: AND pt.credit_check_flag = 'Y'
316: AND NVL(pt.org_id, -99) = NVL(h.org_id,-99))

Line 343: FROM oe_payment_types_all pt

339: AND t.credit_check_flag = 'Y'
340: AND (l.ato_line_id IS NULL OR l.ato_line_id = l.line_id)
341: AND (EXISTS
342: (SELECT NULL
343: FROM oe_payment_types_all pt
344: WHERE pt.payment_type_code = NVL(l.payment_type_code,
345: NVL(h.payment_type_code, 'BME'))
346: AND pt.credit_check_flag = 'Y'
347: AND NVL(pt.org_id, -99) = NVL(h.org_id,-99))

Line 374: FROM oe_payment_types_all pt

370: AND t.credit_check_flag = 'Y'
371: AND (l.ato_line_id IS NULL OR l.ato_line_id = l.line_id)
372: AND (EXISTS
373: (SELECT NULL
374: FROM oe_payment_types_all pt
375: WHERE pt.payment_type_code = NVL(l.payment_type_code,
376: NVL(h.payment_type_code, 'BME'))
377: AND pt.credit_check_flag = 'Y'
378: AND NVL(pt.org_id, -99) = NVL(h.org_id,-99))

Line 3849: FROM oe_payment_types_all pt

3845: AND l.payment_term_id = t.term_id
3846: AND nvl(t.credit_check_flag, 'N') = 'N'
3847: AND (EXISTS
3848: (SELECT 'Y'
3849: FROM oe_payment_types_all pt
3850: WHERE NVL(l.payment_type_code, 'N') = pt.payment_type_code
3851: AND pt.credit_check_flag = 'N'
3852: )
3853: OR l.payment_type_code IS NULL