APPS.OE_HOLDS_PUB dependencies on OE_ORDER_HOLDS_ALL

Line 1245: FROM oe_order_holds_all oh

1241: BEGIN
1242:
1243: SELECT 'ANY_LINE_HOLD'
1244: INTO l_dummy
1245: FROM oe_order_holds_all oh
1246: WHERE oh.header_id = p_hdr_id
1247: and oh.line_id = p_line_id
1248: and oh.hold_release_id is null
1249: AND EXISTS

Line 1372: FROM oe_order_holds_all oh

1368: BEGIN
1369:
1370: SELECT /* MOAC_SQL_CHANGE */ 'ANY_ATO_LINE_HOLD'
1371: INTO l_dummy
1372: FROM oe_order_holds_all oh
1373: WHERE oh.header_id = p_hdr_id
1374: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1375: where ol.header_id = oh.header_id
1376: and ol.ato_line_id = p_ato_line_id

Line 1499: FROM oe_order_holds_all oh

1495: BEGIN
1496:
1497: SELECT /* MOAC_SQL_CHANGE */ 'ANY_SMC_LINE_HOLD'
1498: INTO l_dummy
1499: FROM oe_order_holds_all oh
1500: WHERE oh.header_id = p_hdr_id
1501: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1502: where ol.header_id = oh.header_id
1503: and ol.top_model_line_id = p_top_model_line_id)

Line 1608: FROM oe_order_holds_all oh

1604: BEGIN
1605:
1606: SELECT 'ANY_LINE_HOLD'
1607: INTO l_dummy
1608: FROM oe_order_holds_all oh
1609: WHERE oh.header_id = x_hold_rec.header_id
1610: and OH.LINE_ID is not null
1611: and OH.HOLD_RELEASE_ID IS NULL
1612: and ROWNUM = 1

Line 1823: FROM oe_order_holds_all oh

1819: BEGIN
1820:
1821: SELECT 'ANY_HEADER_HOLD'
1822: INTO l_dummy
1823: FROM oe_order_holds_all oh
1824: WHERE oh.header_id = p_hdr_id
1825: AND oh.line_id IS NULL
1826: AND oh.hold_release_id IS NULL
1827: AND EXISTS

Line 2601: -- Deletes from OE_ORDER_HOLDS all hold records for an order (p_header_id)

2597:
2598:
2599: ----------------------------------------------------------------------------
2600: -- Delete Holds
2601: -- Deletes from OE_ORDER_HOLDS all hold records for an order (p_header_id)
2602: -- or for a line (p_line_id).
2603: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
2604: -- order, deletes hold source records from OE_HOLD_SOURCES.
2605: -- If the hold or hold source was released and the same release record is