View: IGCFV_CC_NUMBER_METHODS

Product:	IGC - Contract Commitment
Description:
Implementation/DBA Data:	APPS.IGCFV_CC_NUMBER_METHODS

View Text

SELECT '_LA:CC_NUM_METHOD:FND_LOOKUPS:IGC_CC_NUMBER_METHOD:MEANING' "_LA:NUMBERING_METHOD"
, '_LA:CC_NUM_DATATYPE:FND_LOOKUPS:IGC_CC_NUMBER_DATATYPE:MEANING' "_LA:NUMBER_DATATYPE"
, ORU.NAME ORGANIZATION_NAME
, CCTYPE.ORG_ID ORGANIZATION_ID
, CCTYPE.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCTYPE.CREATION_DATE CREATION_DATE
, CCTYPE.LAST_UPDATED_BY LAST_UPDATED_BY
, CCTYPE.CREATED_BY CREATED_BY
FROM IGC_CC_NUMBER_METHODS CCTYPE
, HR_ALL_ORGANIZATION_UNITS ORU
WHERE CCTYPE.ORG_ID=ORU.ORGANIZATION_ID
AND '_SEC:CCTYPE.ORG_ID' IS NOT NULL WITH READ ONLY

Columns