DBA Data[Home] [Help]

APPS.OE_MARGIN_PVT dependencies on OE_HOLD_SOURCES

Line 133: OE_HOLD_SOURCES s

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
137: AND H.HOLD_RELEASE_ID IS NOT NULL

Line 155: OE_HOLD_SOURCES s

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
159: AND H.HOLD_RELEASE_ID IS NOT NULL