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