APPS.OE_HOLDS_PUB dependencies on OE_ORDER_HOLDS_ALL

Line 1334: FROM oe_order_holds_all oh

1330: BEGIN
1331:
1332: SELECT 'ANY_LINE_HOLD'
1333: INTO l_dummy
1334: FROM oe_order_holds_all oh
1335: WHERE oh.header_id = p_hdr_id
1336: and oh.line_id = p_line_id
1337: and oh.hold_release_id is null
1338: AND EXISTS

Line 1461: FROM oe_order_holds_all oh

1457: BEGIN
1458:
1459: SELECT /* MOAC_SQL_CHANGE */ 'ANY_ATO_LINE_HOLD'
1460: INTO l_dummy
1461: FROM oe_order_holds_all oh
1462: WHERE oh.header_id = p_hdr_id
1463: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1464: where ol.header_id = oh.header_id
1465: and ol.ato_line_id = p_ato_line_id

Line 1588: FROM oe_order_holds_all oh

1584: BEGIN
1585:
1586: SELECT /* MOAC_SQL_CHANGE */ 'ANY_SMC_LINE_HOLD'
1587: INTO l_dummy
1588: FROM oe_order_holds_all oh
1589: WHERE oh.header_id = p_hdr_id
1590: and oh.line_id in (select ol.line_id from oe_order_lines_all ol
1591: where ol.header_id = oh.header_id
1592: and ol.top_model_line_id = p_top_model_line_id)

Line 1697: FROM oe_order_holds_all oh

1693: BEGIN
1694:
1695: SELECT 'ANY_LINE_HOLD'
1696: INTO l_dummy
1697: FROM oe_order_holds_all oh
1698: WHERE oh.header_id = x_hold_rec.header_id
1699: and OH.LINE_ID is not null
1700: and OH.HOLD_RELEASE_ID IS NULL
1701: and ROWNUM = 1

Line 1912: FROM oe_order_holds_all oh

1908: BEGIN
1909:
1910: SELECT 'ANY_HEADER_HOLD'
1911: INTO l_dummy
1912: FROM oe_order_holds_all oh
1913: WHERE oh.header_id = p_hdr_id
1914: AND oh.line_id IS NULL
1915: AND oh.hold_release_id IS NULL
1916: AND EXISTS

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

2689:
2690:
2691: ----------------------------------------------------------------------------
2692: -- Delete Holds
2693: -- Deletes from OE_ORDER_HOLDS all hold records for an order (p_header_id)
2694: -- or for a line (p_line_id).
2695: -- Also, if there are ORDER hold sources (hold_entity_code = 'O') for this
2696: -- order, deletes hold source records from OE_HOLD_SOURCES.
2697: -- If the hold or hold source was released and the same release record is