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_INTERFACE_UTIL dependencies on OE_PAYMENT_TYPES_ALL

Line 111: FROM oe_payment_types_all pt

107: AND rl.interface_line_attribute1 = h.order_number
108: AND rl.interface_line_attribute6 = l.line_id
109: AND (EXISTS
110: (SELECT NULL
111: FROM oe_payment_types_all pt
112: WHERE pt.payment_type_code = NVL(l.payment_type_code,
113: NVL(h.payment_type_code, 'BME'))
114: AND pt.credit_check_flag = 'Y'
115: AND NVL(pt.org_id, -99) = l_org_id)

Line 144: FROM oe_payment_types_all pt

140: AND rl.interface_line_attribute1 = h.order_number
141: AND rl.interface_line_attribute6 = l.line_id
142: AND (EXISTS
143: (SELECT NULL
144: FROM oe_payment_types_all pt
145: WHERE pt.payment_type_code = NVL(l.payment_type_code,
146: NVL(h.payment_type_code, 'BME'))
147: AND pt.credit_check_flag = 'Y'
148: AND NVL(pt.org_id, -99) = l_org_id)

Line 180: FROM oe_payment_types_all pt

176: AND rl.interface_line_attribute1 = h.order_number
177: AND rl.interface_line_attribute6 = p.price_adjustment_id
178: AND (EXISTS
179: (SELECT NULL
180: FROM oe_payment_types_all pt
181: WHERE pt.payment_type_code = NVL(l.payment_type_code,
182: NVL(h.payment_type_code, 'BME'))
183: AND pt.credit_check_flag = 'Y'
184: AND NVL(pt.org_id, -99) = l_org_id)

Line 210: FROM oe_payment_types_all pt,

206: AND rl.interface_line_attribute1 = h.order_number
207: AND rl.interface_line_attribute6 = p.price_adjustment_id
208: AND EXISTS
209: (SELECT NULL
210: FROM oe_payment_types_all pt,
211: oe_order_lines l
212: WHERE pt.credit_check_flag = 'Y'
213: AND l.header_id = h.header_id
214: AND l.org_id = pt.org_id

Line 250: FROM oe_payment_types_all pt

246: AND rl.interface_line_attribute1 = h.order_number
247: AND rl.interface_line_attribute6 = l.line_id
248: AND (EXISTS
249: (SELECT NULL
250: FROM oe_payment_types_all pt
251: WHERE pt.payment_type_code = NVL(l.payment_type_code,
252: NVL(h.payment_type_code, 'BME'))
253: AND pt.credit_check_flag = 'Y'
254: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 282: FROM oe_payment_types_all pt

278: AND rl.interface_line_attribute1 = h.order_number
279: AND rl.interface_line_attribute6 = l.line_id
280: AND (EXISTS
281: (SELECT NULL
282: FROM oe_payment_types_all pt
283: WHERE pt.payment_type_code = NVL(l.payment_type_code,
284: NVL(h.payment_type_code, 'BME'))
285: AND pt.credit_check_flag = 'Y'
286: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 316: FROM oe_payment_types_all pt

312: AND rl.interface_line_attribute1 = h.order_number
313: AND rl.interface_line_attribute6 = p.price_adjustment_id
314: AND (EXISTS
315: (SELECT NULL
316: FROM oe_payment_types_all pt
317: WHERE pt.payment_type_code = NVL(l.payment_type_code,
318: NVL(h.payment_type_code, 'BME'))
319: AND pt.credit_check_flag = 'Y'
320: AND NVL(pt.org_id, -99) = NVL(h.org_id, -99))

Line 346: FROM oe_payment_types_all pt,

342: AND rl.interface_line_attribute1 = h.order_number
343: AND rl.interface_line_attribute6 = p.price_adjustment_id
344: AND EXISTS
345: (SELECT NULL
346: FROM oe_payment_types_all pt,
347: oe_order_lines l
348: WHERE pt.credit_check_flag = 'Y'
349: AND l.header_id = h.header_id
350: AND l.org_id = pt.org_id