View: CSD_REPAIR_FLOW_STATUSES_V

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.CSD_REPAIR_FLOW_STATUSES_V

View Text

SELECT FS_B.FLOW_STATUS_ID FLOW_STATUS_ID
, FS_B.FLOW_STATUS_CODE FLOW_STATUS_CODE
, FS_LKUP.MEANING FLOW_STATUS_MEANING
, FS_LKUP.DESCRIPTION FLOW_STATUS_DESC
, FS_TL.EXTERNAL_DISPLAY_STATUS
, SS_LKUP.LOOKUP_CODE STATUS_CODE
, SS_LKUP.MEANING STATUS_MEANING
, FS_B.SEEDED_FLAG SEEDED_FLAG
, FS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FS_B.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, FS_B.ATTRIBUTE1 ATTRIBUTE1
, FS_B.ATTRIBUTE2 ATTRIBUTE2
, FS_B.ATTRIBUTE3 ATTRIBUTE3
, FS_B.ATTRIBUTE4 ATTRIBUTE4
, FS_B.ATTRIBUTE5 ATTRIBUTE5
, FS_B.ATTRIBUTE6 ATTRIBUTE6
, FS_B.ATTRIBUTE7 ATTRIBUTE7
, FS_B.ATTRIBUTE8 ATTRIBUTE8
, FS_B.ATTRIBUTE9 ATTRIBUTE9
, FS_B.ATTRIBUTE10 ATTRIBUTE10
, FS_B.ATTRIBUTE11 ATTRIBUTE11
, FS_B.ATTRIBUTE12 ATTRIBUTE12
, FS_B.ATTRIBUTE13 ATTRIBUTE13
, FS_B.ATTRIBUTE14 ATTRIBUTE14
, FS_B.ATTRIBUTE15 ATTRIBUTE15
FROM CSD_FLOW_STATUSES_B FS_B
, CSD_FLOW_STATUSES_TL FS_TL
, FND_LOOKUPS FS_LKUP
, FND_LOOKUPS SS_LKUP
WHERE FS_TL.FLOW_STATUS_ID = FS_B.FLOW_STATUS_ID
AND FS_TL.LANGUAGE = USERENV('LANG')
AND FS_B.FLOW_STATUS_CODE <> 'D'
AND FS_LKUP.LOOKUP_TYPE = 'CSD_REPAIR_FLOW_STATUS'
AND FS_B.FLOW_STATUS_CODE = FS_LKUP.LOOKUP_CODE
AND SS_LKUP.LOOKUP_TYPE = 'CSD_REPAIR_STATUS'
AND FS_B.STATUS_CODE = SS_LKUP.LOOKUP_CODE

Columns