[Home] [Help]
| Product: | CS - Service |
|---|---|
| Description: | View used for find window in counter setup form |
| Implementation/DBA Data: | Not implemented in this database |
SELECT CGR.COUNTER_GROUP_ID
, CGR.NAME COUNTER_GROUP_NAME
, CTR.COUNTER_ID
, CTR.NAME COUNTER_NAME
, CPROP.COUNTER_PROPERTY_ID
, CPROP.NAME COUNTER_PROPERTY_NAME
, CASS.SOURCE_OBJECT_ID ASSOCIATED_ITEM_ID
, ASITM.CONCATENATED_SEGMENTS ASSOCIATED_ITEM_NAME
, CTR.DERIVE_COUNTER_ID
, DCTR.NAME DERIVED_COUNTER_NAME
, CTR.DERIVE_PROPERTY_ID
, DPROP.NAME DERIVED_COUNTER_PROP_NAME
, CGR.ASSOCIATION_TYPE
, CTR.USAGE_ITEM_ID
, USITM.CONCATENATED_SEGMENTS USAGE_ITEM_NAME
FROM CS_COUNTERS CTR
, CS_COUNTERS DCTR
, CS_COUNTER_PROPERTIES CPROP
, CS_COUNTER_PROPERTIES DPROP
, CS_CTR_ASSOCIATIONS CASS
, MTL_SYSTEM_ITEMS_KFV USITM
, MTL_SYSTEM_ITEMS_KFV ASITM
, CS_COUNTER_GROUPS CGR
WHERE CPROP.COUNTER_ID(+) = CTR.COUNTER_ID
AND CTR.COUNTER_GROUP_ID(+) = CGR.COUNTER_GROUP_ID
AND CASS.COUNTER_GROUP_ID(+) = CGR.COUNTER_GROUP_ID
AND DCTR.COUNTER_ID(+) = CTR.DERIVE_COUNTER_ID
AND DPROP.COUNTER_PROPERTY_ID(+) = CPROP.SOURCE_COUNTER_PROP_ID
AND CASS.SOURCE_OBJECT_ID = ASITM.INVENTORY_ITEM_ID(+)
AND CTR.USAGE_ITEM_ID = USITM.INVENTORY_ITEM_ID(+)
AND USITM.ORGANIZATION_ID(+) = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND ASITM.ORGANIZATION_ID(+) = CS_STD.GET_ITEM_VALDN_ORGZN_ID