DBA Data[Home] [Help]

APPS.WIP_JOBCLOSE_PRIV dependencies on WIP_COST_TXN_INTERFACE

Line 121: FROM WIP_COST_TXN_INTERFACE WCTI

117: WHERE WMTI.ORGANIZATION_ID = p_organization_id
118: AND WMTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
119: AND NOT EXISTS
120: (SELECT 'X'
121: FROM WIP_COST_TXN_INTERFACE WCTI
122: WHERE WCTI.ORGANIZATION_ID = p_organization_id
123: AND WCTI.WIP_ENTITY_ID = WE.WIP_ENTITY_ID)
124: AND NOT EXISTS
125: (SELECT 'X'

Line 493: FROM WIP_COST_TXN_INTERFACE

489: FROM WIP_MOVE_TXN_INTERFACE
490: WHERE ORGANIZATION_ID = p_organization_id
491: UNION ALL
492: SELECT WIP_ENTITY_ID
493: FROM WIP_COST_TXN_INTERFACE
494: WHERE ORGANIZATION_ID = p_organization_id
495: UNION ALL
496: SELECT TRANSACTION_SOURCE_ID
497: FROM MTL_MATERIAL_TRANSACTIONS_TEMP MMTT

Line 2097: INSERT INTO WIP_COST_TXN_INTERFACE

2093: SELECT WIP_TRANSACTIONS_S.nextval
2094: INTO l_costing_group_id
2095: FROM DUAL;
2096:
2097: INSERT INTO WIP_COST_TXN_INTERFACE
2098: (LAST_UPDATE_DATE,
2099: LAST_UPDATED_BY,
2100: LAST_UPDATE_LOGIN,
2101: CREATION_DATE,