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 6551: oe_order_holds_all oh

6547: AND p.line_id (+) = m.line_line_id
6548: AND EXISTS
6549: ( SELECT 1
6550: FROM
6551: oe_order_holds_all oh
6552: WHERE
6553: oh.header_id = m.order_header_id
6554: AND ( oh.line_id = m.line_line_id
6555: OR oh.line_id IS NULL

Line 6629: FROM oe_order_holds_all oh

6625: WHERE
6626: m.line_line_category_code = 'ORDER'
6627: AND EXISTS
6628: ( SELECT 1
6629: FROM oe_order_holds_all oh
6630: WHERE oh.header_id = m.order_header_id
6631: AND ( oh.line_id = m.line_line_id
6632: OR oh.line_id IS NULL
6633: )

Line 6734: FROM oe_order_holds_all oh

6730: AND su.cust_acct_site_id = s.cust_acct_site_id
6731: AND ca.cust_account_id = s.cust_account_id
6732: AND EXISTS
6733: ( SELECT 1
6734: FROM oe_order_holds_all oh
6735: WHERE oh.header_id = h.header_id
6736: AND ( oh.line_id = l.line_id
6737: OR oh.line_id IS NULL
6738: )

Line 6820: FROM oe_order_holds_all oh

6816: WHERE
6817: m.line_line_category_code = 'RETURN'
6818: AND EXISTS
6819: ( SELECT 1
6820: FROM oe_order_holds_all oh
6821: WHERE oh.header_id = m.order_header_id
6822: AND ( oh.line_id = m.line_line_id
6823: OR oh.line_id IS NULL
6824: )

Line 6905: FROM oe_order_holds_all oh

6901: AND p.header_id (+) = m.line_header_id
6902: AND p.line_id (+) = m.line_line_id
6903: AND EXISTS
6904: ( SELECT 1
6905: FROM oe_order_holds_all oh
6906: WHERE oh.header_id = m.order_header_id
6907: AND ( oh.line_id = m.line_line_id
6908: OR oh.line_id IS NULL
6909: )

Line 6981: FROM oe_order_holds_all oh

6977: WHERE
6978: m.line_line_category_code = 'ORDER'
6979: AND EXISTS
6980: ( SELECT 1
6981: FROM oe_order_holds_all oh
6982: WHERE oh.header_id = m.order_header_id
6983: AND ( oh.line_id = m.line_line_id
6984: OR oh.line_id IS NULL
6985: )

Line 7068: FROM oe_order_holds_all oh

7064: AND p.header_id (+) = m.line_header_id
7065: AND p.line_id (+) = m.line_line_id
7066: AND EXISTS
7067: ( SELECT 1
7068: FROM oe_order_holds_all oh
7069: WHERE oh.header_id = m.order_header_id
7070: AND ( oh.line_id = m.line_line_id
7071: OR oh.line_id IS NULL
7072: )

Line 7139: FROM oe_order_holds_all oh

7135: WHERE
7136: m.line_line_category_code = 'RETURN'
7137: AND EXISTS
7138: ( SELECT 1
7139: FROM oe_order_holds_all oh
7140: WHERE oh.header_id = m.order_header_id
7141: AND ( oh.line_id = m.line_line_id
7142: OR oh.line_id IS NULL
7143: )

Line 7227: FROM oe_order_holds_all oh

7223: AND p.list_line_type_code = 'FREIGHT_CHARGE'
7224: AND NVL( p.invoiced_flag, 'N' ) = 'N'
7225: AND EXISTS
7226: ( SELECT 1
7227: FROM oe_order_holds_all oh
7228: WHERE oh.header_id = m.order_header_id
7229: AND ( oh.line_id = m.line_line_id
7230: OR oh.line_id IS NULL
7231: )

Line 7317: FROM oe_order_holds_all oh

7313: AND p.list_line_type_code = 'FREIGHT_CHARGE'
7314: AND NVL( p.invoiced_flag, 'N' ) = 'N'
7315: AND EXISTS
7316: ( SELECT 1
7317: FROM oe_order_holds_all oh
7318: WHERE oh.header_id = m.order_header_id
7319: AND ( oh.line_id = m.line_line_id
7320: OR oh.line_id IS NULL
7321: )

Line 7406: FROM oe_order_holds_all oh

7402: AND p.list_line_type_code = 'FREIGHT_CHARGE'
7403: AND NVL( p.invoiced_flag, 'N' ) = 'N'
7404: AND EXISTS
7405: ( SELECT 1
7406: FROM oe_order_holds_all oh
7407: WHERE oh.header_id = m.order_header_id
7408: AND ( oh.line_id = m.line_line_id
7409: OR oh.line_id IS NULL
7410: )

Line 7496: FROM oe_order_holds_all oh

7492: AND p.list_line_type_code = 'FREIGHT_CHARGE'
7493: AND NVL( p.invoiced_flag, 'N' ) = 'N'
7494: AND EXISTS
7495: ( SELECT 1
7496: FROM oe_order_holds_all oh
7497: WHERE oh.header_id = m.order_header_id
7498: AND ( oh.line_id = m.line_line_id
7499: OR oh.line_id IS NULL
7500: )

Line 7587: FROM oe_order_holds_all oh

7583: AND su.cust_acct_site_id = s.cust_acct_site_id
7584: AND ca.cust_account_id = s.cust_account_id
7585: AND EXISTS
7586: ( SELECT 1
7587: FROM oe_order_holds_all oh
7588: WHERE oh.header_id = h.header_id
7589: AND oh.hold_release_id IS NULL
7590: )
7591: AND EXISTS

Line 7688: FROM oe_order_holds_all oh

7684: AND su.cust_acct_site_id = s.cust_acct_site_id
7685: AND ca.cust_account_id = s.cust_account_id
7686: AND EXISTS
7687: ( SELECT 1
7688: FROM oe_order_holds_all oh
7689: WHERE oh.header_id = h.header_id
7690: AND oh.hold_release_id IS NULL
7691: )
7692: AND EXISTS