View: AS_MC_TYPE_MAPPINGS_V

Product:	AS - Sales Foundation
Description:	MC type mappings view
Implementation/DBA Data:	APPS.AS_MC_TYPE_MAPPINGS_V

View Text

SELECT MC.ROWID
, MC.PERIOD_SET_NAME
, MC.PERIOD_TYPE
, MC.CONVERSION_TYPE
, MC.DESCRIPTION
, MC.UPDATEABLE_FLAG
, MC.DELETEABLE_FLAG
, PERIOD.USER_PERIOD_TYPE
, CONVTYPE.USER_CONVERSION_TYPE
, MC.LAST_UPDATE_DATE
, MC.LAST_UPDATED_BY
, MC.CREATION_DATE
, MC.CREATED_BY
, MC.LAST_UPDATE_LOGIN
FROM AS_MC_TYPE_MAPPINGS MC
, GL_DAILY_CONVERSION_TYPES CONVTYPE
, GL_PERIOD_TYPES PERIOD
WHERE MC.PERIOD_TYPE = PERIOD.PERIOD_TYPE(+)
AND MC.CONVERSION_TYPE = CONVTYPE.CONVERSION_TYPE(+)

Columns