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 5794: FROM oe_payment_types_all t

5790: AND ca_l.cust_account_id = s_l.cust_account_id
5791: /*14689044 start
5792: AND EXISTS
5793: ( SELECT NULL
5794: FROM oe_payment_types_all t
5795: WHERE t.credit_check_flag = 'Y'
5796: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
5797: AND l.header_id = h.header_id
5798: AND t.payment_type_code =

Line 5807: FROM OE_PAYMENT_TYPES_ALL T

5803: )
5804: 14689044 end*/
5805: --14689044 start
5806: AND EXISTS ( SELECT /*+ no_unnest */ NULL
5807: FROM OE_PAYMENT_TYPES_ALL T
5808: WHERE T.CREDIT_CHECK_FLAG = 'Y'
5809: AND NVL(T.ORG_ID,-99) = NVL(H.ORG_ID, -99)
5810: AND L.PAYMENT_TYPE_CODE IS NOT NULL
5811: AND T.PAYMENT_TYPE_CODE = L.PAYMENT_TYPE_CODE

Line 5814: FROM OE_PAYMENT_TYPES_ALL T

5810: AND L.PAYMENT_TYPE_CODE IS NOT NULL
5811: AND T.PAYMENT_TYPE_CODE = L.PAYMENT_TYPE_CODE
5812: UNION ALL
5813: SELECT /*+ no_unnest */ NULL
5814: FROM OE_PAYMENT_TYPES_ALL T
5815: WHERE T.CREDIT_CHECK_FLAG = 'Y'
5816: AND NVL(T.ORG_ID,-99) = NVL(H.ORG_ID, -99)
5817: AND L.PAYMENT_TYPE_CODE IS NULL AND H.PAYMENT_TYPE_CODE IS NOT NULL
5818: AND T.PAYMENT_TYPE_CODE = H.PAYMENT_TYPE_CODE

Line 5821: FROM OE_PAYMENT_TYPES_ALL T

5817: AND L.PAYMENT_TYPE_CODE IS NULL AND H.PAYMENT_TYPE_CODE IS NOT NULL
5818: AND T.PAYMENT_TYPE_CODE = H.PAYMENT_TYPE_CODE
5819: UNION ALL
5820: SELECT /*+ no_unnest */ NULL
5821: FROM OE_PAYMENT_TYPES_ALL T
5822: WHERE T.CREDIT_CHECK_FLAG = 'Y'
5823: AND NVL(T.ORG_ID,-99) = NVL(H.ORG_ID, -99)
5824: AND L.PAYMENT_TYPE_CODE IS NULL AND H.PAYMENT_TYPE_CODE IS NULL
5825: )

Line 5883: FROM oe_payment_types_all t

5879: AND ca_l.cust_account_id = s_l.cust_account_id
5880: /*14689044 start
5881: AND EXISTS
5882: ( SELECT NULL
5883: FROM oe_payment_types_all t
5884: WHERE t.credit_check_flag = 'Y'
5885: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
5886: AND l.header_id = h.header_id
5887: AND t.payment_type_code =

Line 5896: FROM OE_PAYMENT_TYPES_ALL T

5892: );
5893: 14689044 end*/
5894: --14689044 start
5895: AND EXISTS ( SELECT /*+ no_unnest */ NULL
5896: FROM OE_PAYMENT_TYPES_ALL T
5897: WHERE T.CREDIT_CHECK_FLAG = 'Y'
5898: AND NVL(T.ORG_ID,-99) = NVL(H.ORG_ID, -99)
5899: AND L.PAYMENT_TYPE_CODE IS NOT NULL
5900: AND T.PAYMENT_TYPE_CODE = L.PAYMENT_TYPE_CODE

Line 5903: FROM OE_PAYMENT_TYPES_ALL T

5899: AND L.PAYMENT_TYPE_CODE IS NOT NULL
5900: AND T.PAYMENT_TYPE_CODE = L.PAYMENT_TYPE_CODE
5901: UNION ALL
5902: SELECT /*+ no_unnest */ NULL
5903: FROM OE_PAYMENT_TYPES_ALL T
5904: WHERE T.CREDIT_CHECK_FLAG = 'Y'
5905: AND NVL(T.ORG_ID,-99) = NVL(H.ORG_ID, -99)
5906: AND L.PAYMENT_TYPE_CODE IS NULL AND H.PAYMENT_TYPE_CODE IS NOT NULL
5907: AND T.PAYMENT_TYPE_CODE = H.PAYMENT_TYPE_CODE

Line 5910: FROM OE_PAYMENT_TYPES_ALL T

5906: AND L.PAYMENT_TYPE_CODE IS NULL AND H.PAYMENT_TYPE_CODE IS NOT NULL
5907: AND T.PAYMENT_TYPE_CODE = H.PAYMENT_TYPE_CODE
5908: UNION ALL
5909: SELECT /*+ no_unnest */ NULL
5910: FROM OE_PAYMENT_TYPES_ALL T
5911: WHERE T.CREDIT_CHECK_FLAG = 'Y'
5912: AND NVL(T.ORG_ID,-99) = NVL(H.ORG_ID, -99)
5913: AND L.PAYMENT_TYPE_CODE IS NULL AND H.PAYMENT_TYPE_CODE IS NULL
5914: );

Line 7230: FROM oe_payment_types_all t,

7226: AND su.cust_acct_site_id = s.cust_acct_site_id
7227: AND ca.cust_account_id = s.cust_account_id
7228: AND EXISTS
7229: ( SELECT NULL
7230: FROM oe_payment_types_all t,
7231: oe_order_lines_all l
7232: WHERE t.credit_check_flag = 'Y'
7233: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7234: AND l.header_id = h.header_id

Line 7294: FROM oe_payment_types_all t,

7290: AND rl.interface_line_attribute1 = h.order_number
7291: AND rl.interface_line_attribute6 = p.price_adjustment_id
7292: AND EXISTS
7293: ( SELECT NULL
7294: FROM oe_payment_types_all t,
7295: oe_order_lines_all l
7296: WHERE t.credit_check_flag = 'Y'
7297: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7298: AND l.header_id = h.header_id

Line 7387: FROM oe_payment_types_all t,

7383: AND su.cust_acct_site_id = s.cust_acct_site_id
7384: AND ca.cust_account_id = s.cust_account_id
7385: AND EXISTS
7386: ( SELECT NULL
7387: FROM oe_payment_types_all t,
7388: oe_order_lines_all l
7389: WHERE t.credit_check_flag = 'Y'
7390: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7391: AND l.header_id = h.header_id

Line 7453: FROM oe_payment_types_all t,

7449: AND rl.interface_line_attribute1 = h.order_number
7450: AND rl.interface_line_attribute6 = p.price_adjustment_id
7451: AND EXISTS
7452: ( SELECT NULL
7453: FROM oe_payment_types_all t,
7454: oe_order_lines_all l
7455: WHERE t.credit_check_flag = 'Y'
7456: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7457: AND l.header_id = h.header_id

Line 7558: FROM oe_payment_types_all t,

7554: AND su.cust_acct_site_id = s.cust_acct_site_id
7555: AND ca.cust_account_id = s.cust_account_id
7556: AND EXISTS
7557: ( SELECT NULL
7558: FROM oe_payment_types_all t,
7559: oe_order_lines_all l
7560: WHERE t.credit_check_flag = 'Y'
7561: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7562: AND l.header_id = h.header_id

Line 7621: FROM oe_payment_types_all t,

7617: AND rl.interface_line_attribute1 = h.order_number
7618: AND rl.interface_line_attribute6 = p.price_adjustment_id
7619: AND EXISTS
7620: ( SELECT NULL
7621: FROM oe_payment_types_all t,
7622: oe_order_lines_all l
7623: WHERE t.credit_check_flag = 'Y'
7624: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7625: AND l.header_id = h.header_id

Line 7711: FROM oe_payment_types_all t,

7707: AND su.cust_acct_site_id = s.cust_acct_site_id
7708: AND ca.cust_account_id = s.cust_account_id
7709: AND EXISTS
7710: ( SELECT NULL
7711: FROM oe_payment_types_all t,
7712: oe_order_lines_all l
7713: WHERE t.credit_check_flag = 'Y'
7714: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7715: AND l.header_id = h.header_id

Line 7776: FROM oe_payment_types_all t,

7772: AND rl.interface_line_attribute1 = h.order_number
7773: AND rl.interface_line_attribute6 = p.price_adjustment_id
7774: AND EXISTS
7775: ( SELECT NULL
7776: FROM oe_payment_types_all t,
7777: oe_order_lines_all l
7778: WHERE t.credit_check_flag = 'Y'
7779: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
7780: AND l.header_id = h.header_id

Line 8073: FROM oe_payment_types_all t

8069: AND oh.hold_release_id IS NULL
8070: )
8071: AND EXISTS
8072: ( SELECT NULL
8073: FROM oe_payment_types_all t
8074: WHERE t.credit_check_flag = 'Y'
8075: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
8076: AND l.header_id = h.header_id
8077: AND t.payment_type_code =

Line 9307: FROM oe_payment_types_all t,

9303: AND oh.hold_release_id IS NULL
9304: )
9305: AND EXISTS
9306: ( SELECT NULL
9307: FROM oe_payment_types_all t,
9308: oe_order_lines_all l
9309: WHERE t.credit_check_flag = 'Y'
9310: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
9311: AND l.header_id = h.header_id

Line 9404: FROM oe_payment_types_all t,

9400: AND oh.hold_release_id IS NULL
9401: )
9402: AND EXISTS
9403: ( SELECT NULL
9404: FROM oe_payment_types_all t,
9405: oe_order_lines_all l
9406: WHERE t.credit_check_flag = 'Y'
9407: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
9408: AND l.header_id = h.header_id

Line 9510: FROM oe_payment_types_all t,

9506: AND oh.hold_release_id IS NULL
9507: )
9508: AND EXISTS
9509: ( SELECT NULL
9510: FROM oe_payment_types_all t,
9511: oe_order_lines_all l
9512: WHERE t.credit_check_flag = 'Y'
9513: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
9514: AND l.header_id = h.header_id

Line 9606: FROM oe_payment_types_all t,

9602: AND oh.hold_release_id IS NULL
9603: )
9604: AND EXISTS
9605: ( SELECT NULL
9606: FROM oe_payment_types_all t,
9607: oe_order_lines_all l
9608: WHERE t.credit_check_flag = 'Y'
9609: AND NVL(t.org_id,-99) = NVL(h.org_id, -99)
9610: AND l.header_id = h.header_id