APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_HOLDS

Line 3436: FROM oe_order_holds

3432:
3433: /* 1931163 */
3434: CURSOR line_on_hold(c_line_id NUMBER) IS
3435: SELECT 'Y' hold_exists
3436: FROM oe_order_holds
3437: WHERE line_id = c_line_id
3438: AND released_flag = 'N';
3439:
3440: CURSOR line_info(c_line_id NUMBER) IS

Line 3452: FROM oe_order_holds ooh, oe_order_lines ool

3448: WHERE line_id = c_line_id;
3449:
3450: CURSOR ato_lines_on_hold(c_ato_line_id NUMBER, c_top_model_line_id NUMBER) IS
3451: SELECT 'Y' hold_exists
3452: FROM oe_order_holds ooh, oe_order_lines ool
3453: where ool.ato_line_id = c_ato_line_id
3454: and ool.top_model_line_id = c_top_model_line_id
3455: and ooh.line_id = ool.line_id
3456: and ooh.released_flag = 'N';

Line 3460: FROM oe_order_holds ooh, oe_order_lines ool

3456: and ooh.released_flag = 'N';
3457:
3458: CURSOR smc_lines_on_hold(c_top_model_line_id NUMBER) IS
3459: SELECT 'Y' hold_exists
3460: FROM oe_order_holds ooh, oe_order_lines ool
3461: where ool.top_model_line_id = c_top_model_line_id
3462: and ooh.line_id = ool.line_id
3463: and ooh.released_flag = 'N';
3464:

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 3569: FROM OE_ORDER_HOLDS

3565: /* 1931163: First check if there is ANY unreleased hold on the order/lines */
3566: BEGIN
3567: SELECT 'Y'
3568: INTO l_hold_exists
3569: FROM OE_ORDER_HOLDS
3570: WHERE HEADER_ID = p_line_rec.header_id
3571: AND RELEASED_FLAG = 'N';
3572: EXCEPTION
3573: WHEN TOO_MANY_ROWS THEN

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;