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_ORDER_HOLDS_ALL

Line 7876: oe_order_holds_all oh

7872: AND m.interface_line_attribute6 = -999 --TaxER
7873: AND EXISTS
7874: ( SELECT 1
7875: FROM
7876: oe_order_holds_all oh
7877: WHERE
7878: oh.header_id = m.order_header_id
7879: AND ( oh.line_id = m.line_line_id
7880: OR oh.line_id IS NULL

Line 7957: FROM oe_order_holds_all oh

7953: m.line_line_category_code = 'ORDER'
7954: AND m.interface_line_attribute6 = -999 --TaxER
7955: AND EXISTS
7956: ( SELECT 1
7957: FROM oe_order_holds_all oh
7958: WHERE oh.header_id = m.order_header_id
7959: AND ( oh.line_id = m.line_line_id
7960: OR oh.line_id IS NULL
7961: )

Line 8064: FROM oe_order_holds_all oh

8060: AND su.cust_acct_site_id = s.cust_acct_site_id
8061: AND ca.cust_account_id = s.cust_account_id
8062: AND EXISTS
8063: ( SELECT 1
8064: FROM oe_order_holds_all oh
8065: WHERE oh.header_id = h.header_id
8066: AND ( oh.line_id = l.line_id
8067: OR oh.line_id IS NULL
8068: )

Line 8154: FROM oe_order_holds_all oh

8150: m.line_line_category_code = 'RETURN'
8151: AND m.interface_line_attribute6 = -999 --TaxER
8152: AND EXISTS
8153: ( SELECT 1
8154: FROM oe_order_holds_all oh
8155: WHERE oh.header_id = m.order_header_id
8156: AND ( oh.line_id = m.line_line_id
8157: OR oh.line_id IS NULL
8158: )

Line 8242: FROM oe_order_holds_all oh

8238: AND p.line_id (+) = m.line_line_id
8239: AND m.interface_line_attribute6 = -999 --TaxER
8240: AND EXISTS
8241: ( SELECT 1
8242: FROM oe_order_holds_all oh
8243: WHERE oh.header_id = m.order_header_id
8244: AND ( oh.line_id = m.line_line_id
8245: OR oh.line_id IS NULL
8246: )

Line 8321: FROM oe_order_holds_all oh

8317: m.line_line_category_code = 'ORDER'
8318: AND m.interface_line_attribute6 = -999 --TaxER
8319: AND EXISTS
8320: ( SELECT 1
8321: FROM oe_order_holds_all oh
8322: WHERE oh.header_id = m.order_header_id
8323: AND ( oh.line_id = m.line_line_id
8324: OR oh.line_id IS NULL
8325: )

Line 8410: FROM oe_order_holds_all oh

8406: AND p.line_id (+) = m.line_line_id
8407: AND m.interface_line_attribute6 = -999 --TaxER
8408: AND EXISTS
8409: ( SELECT 1
8410: FROM oe_order_holds_all oh
8411: WHERE oh.header_id = m.order_header_id
8412: AND ( oh.line_id = m.line_line_id
8413: OR oh.line_id IS NULL
8414: )

Line 8485: FROM oe_order_holds_all oh

8481: m.line_line_category_code = 'RETURN'
8482: AND m.interface_line_attribute6 = -999 --TaxER
8483: AND EXISTS
8484: ( SELECT 1
8485: FROM oe_order_holds_all oh
8486: WHERE oh.header_id = m.order_header_id
8487: AND ( oh.line_id = m.line_line_id
8488: OR oh.line_id IS NULL
8489: )

Line 8577: FROM oe_order_holds_all oh

8573: --TaxER AND NVL( p.invoiced_flag, 'N' ) = 'N'
8574: AND m.interface_line_attribute6 = decode(m.rl_amount,0,-999,p.price_adjustment_id) --TaxER
8575: AND EXISTS
8576: ( SELECT 1
8577: FROM oe_order_holds_all oh
8578: WHERE oh.header_id = m.order_header_id
8579: AND ( oh.line_id = m.line_line_id
8580: OR oh.line_id IS NULL
8581: )

Line 8666: FROM oe_order_holds_all oh

8662: AND m.interface_line_attribute6 = decode(m.rl_amount,0,-999,p.price_adjustment_id) --TaxER
8663: --TaxER AND NVL( p.invoiced_flag, 'N' ) = 'N'
8664: AND EXISTS
8665: ( SELECT 1
8666: FROM oe_order_holds_all oh
8667: WHERE oh.header_id = m.order_header_id
8668: AND ( oh.line_id = m.line_line_id
8669: OR oh.line_id IS NULL
8670: )

Line 8761: FROM oe_order_holds_all oh

8757: --TaxER AND NVL( p.invoiced_flag, 'N' ) = 'N'
8758: AND m.interface_line_attribute6 = decode(m.rl_amount,0,-999,p.price_adjustment_id) --TaxER
8759: AND EXISTS
8760: ( SELECT 1
8761: FROM oe_order_holds_all oh
8762: WHERE oh.header_id = m.order_header_id
8763: AND ( oh.line_id = m.line_line_id
8764: OR oh.line_id IS NULL
8765: )

Line 8845: FROM oe_order_holds_all oh

8841: AND m.interface_line_attribute6 = decode(m.rl_amount,0,-999,p.price_adjustment_id) --TaxER
8842: --TaxER AND NVL( p.invoiced_flag, 'N' ) = 'N'
8843: AND EXISTS
8844: ( SELECT 1
8845: FROM oe_order_holds_all oh
8846: WHERE oh.header_id = m.order_header_id
8847: AND ( oh.line_id = m.line_line_id
8848: OR oh.line_id IS NULL
8849: )

Line 8939: FROM oe_order_holds_all oh

8935: --TaxER AND NVL( p.invoiced_flag, 'N' ) = 'N'
8936: AND m.interface_line_attribute6 = decode(m.rl_amount,0,-999,p.price_adjustment_id) --TaxER
8937: AND EXISTS
8938: ( SELECT 1
8939: FROM oe_order_holds_all oh
8940: WHERE oh.header_id = m.order_header_id
8941: AND ( oh.line_id = m.line_line_id
8942: OR oh.line_id IS NULL
8943: )

Line 9028: FROM oe_order_holds_all oh

9024: AND m.interface_line_attribute6 = decode(m.rl_amount,0,-999,p.price_adjustment_id) --TaxER
9025: --TaxER AND NVL( p.invoiced_flag, 'N' ) = 'N'
9026: AND EXISTS
9027: ( SELECT 1
9028: FROM oe_order_holds_all oh
9029: WHERE oh.header_id = m.order_header_id
9030: AND ( oh.line_id = m.line_line_id
9031: OR oh.line_id IS NULL
9032: )

Line 9124: FROM oe_order_holds_all oh

9120: --TaxER AND NVL( p.invoiced_flag, 'N' ) = 'N'
9121: AND m.interface_line_attribute6 = decode(m.rl_amount,0,-999,p.price_adjustment_id) --TaxER
9122: AND EXISTS
9123: ( SELECT 1
9124: FROM oe_order_holds_all oh
9125: WHERE oh.header_id = m.order_header_id
9126: AND ( oh.line_id = m.line_line_id
9127: OR oh.line_id IS NULL
9128: )

Line 9207: FROM oe_order_holds_all oh

9203: AND m.interface_line_attribute6 = decode(m.rl_amount,0,-999,p.price_adjustment_id) --TaxER
9204: --TaxER AND NVL( p.invoiced_flag, 'N' ) = 'N'
9205: AND EXISTS
9206: ( SELECT 1
9207: FROM oe_order_holds_all oh
9208: WHERE oh.header_id = m.order_header_id
9209: AND ( oh.line_id = m.line_line_id
9210: OR oh.line_id IS NULL
9211: )

Line 9301: FROM oe_order_holds_all oh

9297: AND su.cust_acct_site_id = s.cust_acct_site_id
9298: AND ca.cust_account_id = s.cust_account_id
9299: AND EXISTS
9300: ( SELECT 1
9301: FROM oe_order_holds_all oh
9302: WHERE oh.header_id = h.header_id
9303: AND oh.hold_release_id IS NULL
9304: )
9305: AND EXISTS

Line 9398: FROM oe_order_holds_all oh

9394: AND su.cust_acct_site_id = s.cust_acct_site_id
9395: AND ca.cust_account_id = s.cust_account_id
9396: AND EXISTS
9397: ( SELECT 1
9398: FROM oe_order_holds_all oh
9399: WHERE oh.header_id = h.header_id
9400: AND oh.hold_release_id IS NULL
9401: )
9402: AND EXISTS

Line 9504: FROM oe_order_holds_all oh

9500: AND su.cust_acct_site_id = s.cust_acct_site_id
9501: AND ca.cust_account_id = s.cust_account_id
9502: AND EXISTS
9503: ( SELECT 1
9504: FROM oe_order_holds_all oh
9505: WHERE oh.header_id = h.header_id
9506: AND oh.hold_release_id IS NULL
9507: )
9508: AND EXISTS

Line 9600: FROM oe_order_holds_all oh

9596: AND su.cust_acct_site_id = s.cust_acct_site_id
9597: AND ca.cust_account_id = s.cust_account_id
9598: AND EXISTS
9599: ( SELECT 1
9600: FROM oe_order_holds_all oh
9601: WHERE oh.header_id = h.header_id
9602: AND oh.hold_release_id IS NULL
9603: )
9604: AND EXISTS