Skip to content
[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 |
APPS.IGC_CC_NUMBER_METHODS_V