DBA Data[Home] [Help]

APPS.OE_PURGE_WF dependencies on OE_ORDER_LINES_ALL

Line 180: FROM OE_ORDER_LINES_ALL

176: AND WAS.ACTIVITY_STATUS = 'NOTIFIED'
177: AND WAS.ITEM_TYPE = 'OEOH'
178: AND NOT EXISTS
179: (SELECT 1
180: FROM OE_ORDER_LINES_ALL
181: WHERE HEADER_ID = H.HEADER_ID
182: AND OPEN_FLAG = 'Y'
183: );
184: CURSOR CLOSE_SPECIFIC(c_item_key VARCHAR2 )

Line 202: FROM OE_ORDER_LINES_ALL

198: AND WAS.item_key = c_item_key
199: AND WAS.ITEM_TYPE = 'OEOH'
200: AND NOT EXISTS
201: (SELECT 1
202: FROM OE_ORDER_LINES_ALL
203: WHERE HEADER_ID = H.HEADER_ID
204: AND OPEN_FLAG = 'Y'
205: );
206: CURSOR ERRORS (c_header_id NUMBER)