APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_MOVE_TXN_INTERFACE

Line 133: (SELECT 'X' FROM WIP_MOVE_TXN_INTERFACE WMTI

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
134: WHERE WMTI.ORGANIZATION_ID = p_organization_id
135: AND WMTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
136: AND NOT EXISTS
137: (SELECT 'X'

Line 244: FROM WIP_MOVE_TXN_INTERFACE WMTI

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'
244: FROM WIP_MOVE_TXN_INTERFACE WMTI
245: WHERE WMTI.ORGANIZATION_ID = p_organization_id
246: AND WMTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
247: AND NOT EXISTS ( SELECT 'X'
248: FROM WIP_COST_TXN_INTERFACE WCTI

Line 348: (SELECT 'X' FROM WIP_MOVE_TXN_INTERFACE WMTI

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
349: WHERE WMTI.ORGANIZATION_ID = p_organization_id
350: AND WMTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
351: AND NOT EXISTS
352: (SELECT 'X'

Line 756: FROM WIP_MOVE_TXN_INTERFACE

752: WHERE GROUP_ID = p_group_id
753: AND ORGANIZATION_ID = p_organization_id
754: AND WIP_ENTITY_ID IN
755: (SELECT WIP_ENTITY_ID
756: FROM WIP_MOVE_TXN_INTERFACE
757: WHERE ORGANIZATION_ID = p_organization_id
758: UNION ALL
759: SELECT WIP_ENTITY_ID
760: FROM WIP_COST_TXN_INTERFACE