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_OE_FORM_LINE dependencies on OE_HOLD_SOURCES

Line 3467: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs

3463: and ooh.released_flag = 'N';
3464:
3465: CURSOR link_to_line_hold(c_link_to_line_id NUMBER) IS
3466: SELECT 'Y' hold_exists
3467: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs
3468: where ooh.line_id = c_link_to_line_id
3469: and ooh.released_flag = 'N'
3470: and ohs.hold_source_id = ooh.hold_source_id
3471: and ohs.hold_id = ohd.hold_id

Line 3648: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs

3644:
3645: IF l_cascade_hold_non_smc <> 'Y' THEN
3646: SELECT 'Y' hold_exists
3647: INTO l_hold_exists
3648: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs
3649: where ooh.line_id = l_top_model_line_id
3650: and ooh.released_flag = 'N'
3651: and ohs.hold_source_id = ooh.hold_source_id
3652: and ohs.hold_id = ohd.hold_id

Line 3658: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs

3654: --ER#7479609 start
3655: ELSE
3656: SELECT 'Y' hold_exists
3657: INTO l_hold_exists
3658: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs
3659: where ooh.line_id = l_top_model_line_id
3660: and ooh.released_flag = 'N'
3661: and ohs.hold_source_id = ooh.hold_source_id
3662: and ohs.hold_id = ohd.hold_id;