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

Line 5183: FROM oe_payment_types_all t

5179: AND su_l.cust_acct_site_id = s_l.cust_acct_site_id
5180: AND ca_l.cust_account_id = s_l.cust_account_id
5181: AND EXISTS
5182: ( SELECT NULL
5183: FROM oe_payment_types_all t
5184: WHERE t.credit_check_flag = 'Y'
5185: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
5186: AND l.header_id = h.header_id
5187: AND t.payment_type_code =

Line 5245: FROM oe_payment_types_all t

5241: AND su_l.cust_acct_site_id = s_l.cust_acct_site_id
5242: AND ca_l.cust_account_id = s_l.cust_account_id
5243: AND EXISTS
5244: ( SELECT NULL
5245: FROM oe_payment_types_all t
5246: WHERE t.credit_check_flag = 'Y'
5247: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
5248: AND l.header_id = h.header_id
5249: AND t.payment_type_code =

Line 6226: FROM oe_payment_types_all t,

6222: AND su.cust_acct_site_id = s.cust_acct_site_id
6223: AND ca.cust_account_id = s.cust_account_id
6224: AND EXISTS
6225: ( SELECT NULL
6226: FROM oe_payment_types_all t,
6227: oe_order_lines_all l
6228: WHERE t.credit_check_flag = 'Y'
6229: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
6230: AND l.header_id = h.header_id

Line 6290: FROM oe_payment_types_all t,

6286: AND rl.interface_line_attribute1 = h.order_number
6287: AND rl.interface_line_attribute6 = p.price_adjustment_id
6288: AND EXISTS
6289: ( SELECT NULL
6290: FROM oe_payment_types_all t,
6291: oe_order_lines_all l
6292: WHERE t.credit_check_flag = 'Y'
6293: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
6294: AND l.header_id = h.header_id

Line 6391: FROM oe_payment_types_all t,

6387: AND su.cust_acct_site_id = s.cust_acct_site_id
6388: AND ca.cust_account_id = s.cust_account_id
6389: AND EXISTS
6390: ( SELECT NULL
6391: FROM oe_payment_types_all t,
6392: oe_order_lines_all l
6393: WHERE t.credit_check_flag = 'Y'
6394: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
6395: AND l.header_id = h.header_id

Line 6454: FROM oe_payment_types_all t,

6450: AND rl.interface_line_attribute1 = h.order_number
6451: AND rl.interface_line_attribute6 = p.price_adjustment_id
6452: AND EXISTS
6453: ( SELECT NULL
6454: FROM oe_payment_types_all t,
6455: oe_order_lines_all l
6456: WHERE t.credit_check_flag = 'Y'
6457: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
6458: AND l.header_id = h.header_id

Line 6743: FROM oe_payment_types_all t

6739: AND oh.hold_release_id IS NULL
6740: )
6741: AND EXISTS
6742: ( SELECT NULL
6743: FROM oe_payment_types_all t
6744: WHERE t.credit_check_flag = 'Y'
6745: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
6746: AND l.header_id = h.header_id
6747: AND t.payment_type_code =

Line 7593: FROM oe_payment_types_all t,

7589: AND oh.hold_release_id IS NULL
7590: )
7591: AND EXISTS
7592: ( SELECT NULL
7593: FROM oe_payment_types_all t,
7594: oe_order_lines_all l
7595: WHERE t.credit_check_flag = 'Y'
7596: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7597: AND l.header_id = h.header_id

Line 7694: FROM oe_payment_types_all t,

7690: AND oh.hold_release_id IS NULL
7691: )
7692: AND EXISTS
7693: ( SELECT NULL
7694: FROM oe_payment_types_all t,
7695: oe_order_lines_all l
7696: WHERE t.credit_check_flag = 'Y'
7697: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7698: AND l.header_id = h.header_id