DBA Data[Home] [Help]

APPS.ONT_OEXIODIS_XMLP_PKG dependencies on OE_ORDER_HOLDS_ALL

Line 269: OE_ORDER_HOLDS_ALL

265: SELECT
266: COUNT(ORDER_HOLD_ID)
267: INTO L_NUM_HOLD
268: FROM
269: OE_ORDER_HOLDS_ALL
270: WHERE HEADER_ID = OM_HEADER_ID
271: AND HOLD_RELEASE_ID is null
272: AND ( LINE_ID = OM_LINE_ID
273: OR LINE_ID is null );