[Home] [Help]
View: IGC_CC_NUMBER_METHODS_V
View Text
SELECT CCT.ROWID
, CCT.ORG_ID
, CCT.CC_NUM_METHOD
, LKP2.MEANING CC_NUM_METHOD_DESC
, CCT.CC_NUM_DATATYPE
, LKP3.MEANING CC_NUM_DATATYPE_DESC
, CCT.CC_NEXT_NUM
, CCT.LAST_UPDATE_DATE
, CCT.LAST_UPDATED_BY
, CCT.LAST_UPDATE_LOGIN
, CCT.CREATION_DATE
, CCT.CREATED_BY
FROM IGC_CC_NUMBER_METHODS CCT
, FND_LOOKUPS LKP2
, FND_LOOKUPS LKP3
WHERE CCT.CC_NUM_METHOD = LKP2.LOOKUP_CODE (+)
AND LKP2.LOOKUP_TYPE (+) = 'IGC_CC_NUMBER_METHOD'
AND CCT.CC_NUM_DATATYPE = LKP3.LOOKUP_CODE (+)
AND LKP3.LOOKUP_TYPE (+) = 'IGC_CC_NUMBER_DATATYPE'
Columns
Name |
ROW_ID |
ORG_ID |
CC_NUM_METHOD |
CC_NUM_METHOD_DESC |
CC_NUM_DATATYPE |
CC_NUM_DATATYPE_DESC |
CC_NEXT_NUM |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATION_DATE |
CREATED_BY |