DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WSM_SPLIT_MERGE_TRANSACTIONS

Line 147: wsm_split_merge_transactions wmt

143: AND (WE.ENTITY_TYPE <> 5 OR
144: (WE.ENTITY_TYPE = 5 AND NOT EXISTS
145: (SELECT 'X'
146: FROM wsm_sm_starting_jobs sj,
147: wsm_split_merge_transactions wmt
148: WHERE sj.wip_entity_id = we.wip_entity_id
149: AND sj.transaction_id = wmt.transaction_id
150: AND (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))))
151: AND (WE.ENTITY_TYPE <> 5 OR

Line 155: wsm_split_merge_transactions wmt

151: AND (WE.ENTITY_TYPE <> 5 OR
152: (WE.ENTITY_TYPE = 5 AND NOT EXISTS
153: (SELECT 'X'
154: FROM wsm_sm_resulting_jobs rj,
155: wsm_split_merge_transactions wmt
156: WHERE rj.wip_entity_id = we.wip_entity_id
157: AND rj.transaction_id = wmt.transaction_id
158: AND (wmt.status <> 4 or nvl(wmt.costed,1) <> 4))))))
159: GROUP BY DJ.WIP_ENTITY_ID, DJ.ORGANIZATION_ID, WE.WIP_ENTITY_NAME,