VIEW: APPS.CSD_REPAIR_FLOW_STATUSES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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