DBA Data[Home] [Help]

APPS.OE_MARGIN_PVT dependencies on OE_ORDER_HOLDS

Line 132: FROM OE_ORDER_HOLDS h,

128: IF p_line_id IS NULL THEN
129: BEGIN
130: SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
131: INTO l_hold_release_id
132: FROM OE_ORDER_HOLDS h,
133: OE_HOLD_SOURCES s
134: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
135: AND H.HEADER_ID = p_header_id
136: AND H.LINE_ID IS NULL

Line 154: FROM OE_ORDER_HOLDS h,

150: ELSE
151: BEGIN
152: SELECT NVL(MAX(H.HOLD_RELEASE_ID),0)
153: INTO l_hold_release_id
154: FROM OE_ORDER_HOLDS h,
155: OE_HOLD_SOURCES s
156: WHERE H.HOLD_SOURCE_ID = S.HOLD_SOURCE_ID
157: AND H.HEADER_ID = p_header_id
158: AND H.LINE_ID = p_line_id