[Home] [Help]
125: DJ.DATE_RELEASED < p_to_release_date +1)
126: AND ( p_status IS NULL OR DJ.STATUS_TYPE = p_status)
127: -- AND ( DJ.DATE_RELEASED <= p_act_close_date) /* Bug 5007538 */
128: AND ( p_exclude_reserved_jobs <> '1' OR NOT EXISTS
129: (SELECT 'X'FROM WIP_RESERVATIONS_V WRV
130: WHERE WRV.WIP_ENTITY_ID = WE.WIP_ENTITY_ID ))
131: AND ( p_uncompleted_jobs <> '1' or DJ.STATUS_TYPE IN (4,5)) /* Bug 15896253 */
132: AND ( p_exclude_pending_txn_jobs <> '1' OR ( NOT EXISTS
133: (SELECT 'X' FROM WIP_MOVE_TXN_INTERFACE WMTI
235: AND ( p_to_release_date IS NULL OR DJ.DATE_RELEASED < p_to_release_date +1 )
236: AND ( p_status IS NULL OR DJ.STATUS_TYPE = p_status )
237: AND ( p_exclude_reserved_jobs <> '1'
238: OR NOT EXISTS ( SELECT 'X'
239: FROM WIP_RESERVATIONS_V WRV
240: WHERE WRV.WIP_ENTITY_ID = WE.WIP_ENTITY_ID ) )
241: AND ( p_uncompleted_jobs <> '1' or DJ.STATUS_TYPE IN (4,5)) /* Bug 15896253 */
242: AND ( p_exclude_pending_txn_jobs <> '1'
243: OR ( NOT EXISTS ( SELECT 'X'
340: DJ.DATE_RELEASED < p_to_release_date +1)
341: AND ( p_status IS NULL OR DJ.STATUS_TYPE = p_status)
342: -- AND ( DJ.DATE_RELEASED <= p_act_close_date) /* Bug 5007538 */
343: AND ( p_exclude_reserved_jobs <> '1' OR NOT EXISTS
344: (SELECT 'X'FROM WIP_RESERVATIONS_V WRV
345: WHERE WRV.WIP_ENTITY_ID = WE.WIP_ENTITY_ID ))
346: AND ( p_uncompleted_jobs <> '1' or DJ.STATUS_TYPE IN (4,5)) /* Bug 15896253 */
347: AND ( p_exclude_pending_txn_jobs <> '1' OR ( NOT EXISTS
348: (SELECT 'X' FROM WIP_MOVE_TXN_INTERFACE WMTI
1578: CURSOR C_del_reservation IS
1579: /* fix for bug 8681037 (FP 8461467) */
1580:
1581: /* SELECT wrv.reservation_id
1582: FROM wip_reservations_v wrv,
1583: wip_dj_close_temp wdct
1584: WHERE wdct.organization_id = p_organization_id
1585: AND wdct.group_id = p_group_id
1586: AND wdct.wip_entity_id = wrv.wip_entity_id;