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 3400: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs

3396: and ooh.released_flag = 'N';
3397:
3398: CURSOR link_to_line_hold(c_link_to_line_id NUMBER) IS
3399: SELECT 'Y' hold_exists
3400: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs
3401: where ooh.line_id = c_link_to_line_id
3402: and ooh.released_flag = 'N'
3403: and ohs.hold_source_id = ooh.hold_source_id
3404: and ohs.hold_id = ohd.hold_id

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

3545:
3546: IF l_cascade_hold_non_smc <> 'Y' THEN
3547: SELECT 'Y' hold_exists
3548: INTO l_hold_exists
3549: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs
3550: where ooh.line_id = l_top_model_line_id
3551: and ooh.released_flag = 'N'
3552: and ohs.hold_source_id = ooh.hold_source_id
3553: and ohs.hold_id = ohd.hold_id

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

3555: --ER#7479609 start
3556: ELSE
3557: SELECT 'Y' hold_exists
3558: INTO l_hold_exists
3559: FROM oe_order_holds ooh, oe_hold_definitions ohd, oe_hold_sources ohs
3560: where ooh.line_id = l_top_model_line_id
3561: and ooh.released_flag = 'N'
3562: and ohs.hold_source_id = ooh.hold_source_id
3563: and ohs.hold_id = ohd.hold_id;