DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG6 dependencies on CSD_FLWSTS_TRANS_B

Line 250: insert into CSD_FLWSTS_TRANS_B (

246: and T.LANGUAGE = L.LANGUAGE_CODE);
247:
248: -- STEP 2: Insert into the status transitions for each Repair Type.
249:
250: insert into CSD_FLWSTS_TRANS_B (
251: REPAIR_TYPE_ID,
252: FROM_FLOW_STATUS_ID,
253: TO_FLOW_STATUS_ID,
254: WF_ITEM_TYPE,

Line 290: FROM CSD_FLWSTS_TRANS_B FLWSTS_B

286: AND FS_B2.flow_status_code IN ('C','H','O')
287: AND FS_B2.flow_status_code <> FS_B1.flow_status_code
288: AND NOT EXISTS
289: ( SELECT 'x'
290: FROM CSD_FLWSTS_TRANS_B FLWSTS_B
291: WHERE FLWSTS_B.repair_type_id = RT.repair_type_id
292: AND FLWSTS_B.from_flow_status_id = FS_B1.flow_status_id
293: AND FLWSTS_B.to_flow_status_id = FS_B2.flow_status_id
294: );

Line 319: CSD_FLWSTS_TRANS_B FLWSTS_B

315: FND_GLOBAL.login_id,
316: L.LANGUAGE_CODE,
317: L.LANGUAGE_CODE
318: from FND_LANGUAGES L,
319: CSD_FLWSTS_TRANS_B FLWSTS_B
320: where L.INSTALLED_FLAG in ('I', 'B')
321: and not exists
322: (select 'x'
323: from CSD_FLWSTS_TRANS_TL T