View: GMF_COST_CMPNT_CLASS_SLA_V

Product:	GMF - Process Manufacturing Financials
Description:	View for the value set , GMF_COST_CMPNT_CLASS_SLA
Implementation/DBA Data:	APPS.GMF_COST_CMPNT_CLASS_SLA_V

View Text

SELECT COST_CMPNTCLS_ID
, COST_CMPNTCLS_CODE
, COST_CMPNTCLS_DESC
, SORT_SEQUENCE
, USAGE_IND
, PRIMARY_CMPNTCLS_ID
, PRODUCT_COST_IND
, UPDATE_COST_IND
, CMPNT_GROUP
, TEXT_CODE
, TRANS_CNT
, DELETE_MARK
, PPV_IND
FROM CM_CMPT_MST
WHERE DELETE_MARK = 0 UNION SELECT 0 COST_CMPNTCLS_ID
, '' COST_CMPNTCLS_CODE
, '' COST_CMPNTCLS_DESC
, 0 SORT_SEQUENCE
, 0 USAGE_IND
, 0 PRIMARY_CMPNTCLS_ID
, 0 PRODUCT_COST_IND
, 0 UPDATE_COST_IND
, ''CMPNT_GROUP
, 0 TEXT_CODE
, 0 TRANS_CNT
, 0 DELETE_MARK
, 0 PPV_IND
FROM DUAL

Columns