Product: | CSI - Install Base |
---|---|
Description: | Counter template view |
Implementation/DBA Data: | APPS.CSI_COUNTER_TEMPLATE_V |
SELECT CCTB.COUNTER_ID COUNTER_ID
, CCTB.GROUP_ID GROUP_ID
, CCTB.NAME COUNTER_NAME
, CCTB.DESCRIPTION COUNTER_DESCRIPTION
, CCG.NAME COUNTER_GROUP_NAME
, CCG.DESCRIPTION COUNTER_GROUP_DESCRIPTION
, CCTB.COUNTER_TYPE COUNTER_TYPE
, CCTB.INITIAL_READING INITIAL_READING
, CCTB.STEP_VALUE STEP_VALUE
, CCTB.TOLERANCE_PLUS TOLERANCE_PLUS
, CCTB.TOLERANCE_MINUS TOLERANCE_MINUS
, CCTB.UOM_CODE UOM_CODE
, MUM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CCTB.DERIVE_COUNTER_ID DERIVE_COUNTER_ID
, CCTB.DERIVE_FUNCTION DERIVE_FUNCTION
, CCTB.DERIVE_PROPERTY_ID DERIVE_PROPERTY_ID
, CCPB.NAME DERIVE_COUNTER_NAME
, CCTB.VALID_FLAG VALID_FLAG
, CCTB.FORMULA_INCOMPLETE_FLAG FORMULA_INCOMPLETE_FLAG
, CCTB.FORMULA_TEXT FORMULA_TEXT
, CCTB.ROLLOVER_LAST_READING ROLLOVER_LAST_READING
, CCTB.ROLLOVER_FIRST_READING ROLLOVER_FIRST_READING
, CCTB.USAGE_ITEM_ID USAGE_ITEM_ID
, MSI.CONCATENATED_SEGMENTS USAGE_ITEM_NAME
, CCTB.CTR_VAL_MAX_SEQ_NO CTR_VAL_MAX_SEQ_NO
, CCTB.START_DATE_ACTIVE START_DATE_ACTIVE
, CCTB.END_DATE_ACTIVE END_DATE_ACTIVE
, CCTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCTB.LAST_UPDATED_BY LAST_UPDATED_BY
, CCTB.CREATION_DATE CREATION_DATE
, CCTB.CREATED_BY CREATED_BY
, CCTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCTB.ATTRIBUTE1 ATTRIBUTE1
, CCTB.ATTRIBUTE2 ATTRIBUTE2
, CCTB.ATTRIBUTE3 ATTRIBUTE3
, CCTB.ATTRIBUTE4 ATTRIBUTE4
, CCTB.ATTRIBUTE5 ATTRIBUTE5
, CCTB.ATTRIBUTE6 ATTRIBUTE6
, CCTB.ATTRIBUTE7 ATTRIBUTE7
, CCTB.ATTRIBUTE8 ATTRIBUTE8
, CCTB.ATTRIBUTE9 ATTRIBUTE9
, CCTB.ATTRIBUTE10 ATTRIBUTE10
, CCTB.ATTRIBUTE11 ATTRIBUTE11
, CCTB.ATTRIBUTE12 ATTRIBUTE12
, CCTB.ATTRIBUTE13 ATTRIBUTE13
, CCTB.ATTRIBUTE14 ATTRIBUTE14
, CCTB.ATTRIBUTE15 ATTRIBUTE15
, CCTB.ATTRIBUTE16 ATTRIBUTE16
, CCTB.ATTRIBUTE17 ATTRIBUTE17
, CCTB.ATTRIBUTE18 ATTRIBUTE18
, CCTB.ATTRIBUTE19 ATTRIBUTE19
, CCTB.ATTRIBUTE20 ATTRIBUTE20
, CCTB.ATTRIBUTE21 ATTRIBUTE21
, CCTB.ATTRIBUTE22 ATTRIBUTE22
, CCTB.ATTRIBUTE23 ATTRIBUTE23
, CCTB.ATTRIBUTE24 ATTRIBUTE24
, CCTB.ATTRIBUTE25 ATTRIBUTE25
, CCTB.ATTRIBUTE26 ATTRIBUTE26
, CCTB.ATTRIBUTE27 ATTRIBUTE27
, CCTB.ATTRIBUTE28 ATTRIBUTE28
, CCTB.ATTRIBUTE29 ATTRIBUTE29
, CCTB.ATTRIBUTE30 ATTRIBUTE30
, CCTB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCTB.MIGRATED_FLAG MIGRATED_FLAG
, CCTB.CUSTOMER_VIEW CUSTOMER_VIEW
, CCTB.DIRECTION DIRECTION
, CCTB.FILTER_TYPE FILTER_TYPE
, CCTB.FILTER_READING_COUNT FILTER_READING_COUNT
, CCTB.FILTER_TIME_UOM FILTER_TIME_UOM
, CCTB.ESTIMATION_ID ESTIMATION_ID
, CCEB.NAME ESTIMATION_NAME
, CCTB.READING_TYPE READING_TYPE
, CCTB.AUTOMATIC_ROLLOVER AUTOMATIC_ROLLOVER
, CCTB.DEFAULT_USAGE_RATE DEFAULT_USAGE_RATE
, CCTB.USE_PAST_READING USE_PAST_READING
, CCTB.USED_IN_SCHEDULING USED_IN_SCHEDULING
, CCTB.DEFAULTED_GROUP_ID DEFAULTED_GROUP_ID
, CCTB.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CCTB.COMMENTS COMMENTS
, CCTB.INITIAL_READING_DATE INITIAL_READING_DATE
, CCTB.ASSOCIATION_TYPE ASSOCIATION_TYPE
FROM CSI_COUNTER_TEMPLATE_VL CCTB
, MTL_UNITS_OF_MEASURE MUM
, MTL_SYSTEM_ITEMS_KFV MSI
, CSI_CTR_ESTIMATE_METHODS_VL CCEB
, CSI_CTR_PROP_TEMPLATE_VL CCPB
, CS_COUNTER_GROUPS CCG
WHERE CCTB.ESTIMATION_ID = CCEB.ESTIMATION_ID (+)
AND CCTB.DERIVE_PROPERTY_ID = CCPB.COUNTER_PROPERTY_ID(+)
AND CCTB.USAGE_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND MSI.ORGANIZATION_ID = FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')
AND CCTB.UOM_CODE = MUM.UOM_CODE (+)
AND CCTB.DEFAULTED_GROUP_ID = CCG.COUNTER_GROUP_ID