APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_COST_TXN_INTERFACE

Line 138: FROM WIP_COST_TXN_INTERFACE WCTI

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'
138: FROM WIP_COST_TXN_INTERFACE WCTI
139: WHERE WCTI.ORGANIZATION_ID = p_organization_id
140: AND WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
141: AND NOT EXISTS
142: (SELECT 'X'

Line 248: FROM WIP_COST_TXN_INTERFACE WCTI

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
249: WHERE WCTI.ORGANIZATION_ID = p_organization_id
250: AND WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
251: AND NOT EXISTS ( SELECT 'X'
252: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

Line 353: FROM WIP_COST_TXN_INTERFACE WCTI

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'
353: FROM WIP_COST_TXN_INTERFACE WCTI
354: WHERE WCTI.ORGANIZATION_ID = p_organization_id
355: AND WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
356: AND NOT EXISTS
357: (SELECT 'X'

Line 760: FROM WIP_COST_TXN_INTERFACE

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
761: WHERE ORGANIZATION_ID = p_organization_id
762: UNION ALL
763: SELECT TRANSACTION_SOURCE_ID
764: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

Line 2598: INSERT INTO WIP_COST_TXN_INTERFACE

2594: SELECT WIP_TRANSACTIONS_S.nextval
2595: INTO l_costing_group_id
2596: FROM DUAL;
2597:
2598: INSERT INTO WIP_COST_TXN_INTERFACE
2599: (LAST_UPDATE_DATE,
2600: LAST_UPDATED_BY,
2601: LAST_UPDATE_LOGIN,
2602: CREATION_DATE,