APPS.OE_OE_FORM_LINE dependencies on OE_ORDER_HOLDS

Line 3369: FROM oe_order_holds

3365:
3366: /* 1931163 */
3367: CURSOR line_on_hold(c_line_id NUMBER) IS
3368: SELECT 'Y' hold_exists
3369: FROM oe_order_holds
3370: WHERE line_id = c_line_id
3371: AND released_flag = 'N';
3372:
3373: CURSOR line_info(c_line_id NUMBER) IS

Line 3385: FROM oe_order_holds ooh, oe_order_lines ool

3381: WHERE line_id = c_line_id;
3382:
3383: CURSOR ato_lines_on_hold(c_ato_line_id NUMBER, c_top_model_line_id NUMBER) IS
3384: SELECT 'Y' hold_exists
3385: FROM oe_order_holds ooh, oe_order_lines ool
3386: where ool.ato_line_id = c_ato_line_id
3387: and ool.top_model_line_id = c_top_model_line_id
3388: and ooh.line_id = ool.line_id
3389: and ooh.released_flag = 'N';

Line 3393: FROM oe_order_holds ooh, oe_order_lines ool

3389: and ooh.released_flag = 'N';
3390:
3391: CURSOR smc_lines_on_hold(c_top_model_line_id NUMBER) IS
3392: SELECT 'Y' hold_exists
3393: FROM oe_order_holds ooh, oe_order_lines ool
3394: where ool.top_model_line_id = c_top_model_line_id
3395: and ooh.line_id = ool.line_id
3396: and ooh.released_flag = 'N';
3397:

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

3466: /* 1931163: First check if there is ANY unreleased hold on the order/lines */
3467: BEGIN
3468: SELECT 'Y'
3469: INTO l_hold_exists
3470: FROM OE_ORDER_HOLDS
3471: WHERE HEADER_ID = p_line_rec.header_id
3472: AND RELEASED_FLAG = 'N';
3473: EXCEPTION
3474: WHEN TOO_MANY_ROWS THEN

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;