[Home] [Help]
View: CSD_FLWSTS_MILESTONES_V
View Text
SELECT MILES.FLWSTS_TRAN_MILE_ID FLWSTS_TRAN_MILE_ID
, MILES.FLWSTS_TRAN_ID FLWSTS_TRAN_ID
, MILES_LKUP.LOOKUP_CODE MILESTONE_CODE
, MILES_LKUP.MEANING MILESTONE
, MILES.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM CSD_FLWSTS_TRAN_MILES MILES
, FND_LOOKUPS MILES_LKUP
WHERE MILES_LKUP.LOOKUP_TYPE = 'CSD_REPAIR_MILESTONES'
AND MILES_LKUP.LOOKUP_CODE = MILES.MILESTONE_CODE
Columns
Name |
FLWSTS_TRAN_MILE_ID |
FLWSTS_TRAN_ID |
MILESTONE_CODE |
MILESTONE |
OBJECT_VERSION_NUMBER |