VIEW: APPS.JTF_BRM_WF_ATTR_V

Source

View Text - Preformatted

SELECT wal.ROWID row_id , jbs.wf_attr_value_id wf_attr_value_id , jbs.process_id wf_process_id , wal.activity_item_type wf_item_type , wal.activity_name wf_process_name , wal.activity_version wf_process_version , wal.name wf_attribute_name , wal.display_name wf_attribute_display_name , wal.description wf_attribute_description , wal.type wf_attribute_type , wal.format wf_attribute_format , JTF_BRM_UTILITY_PVT.Attribute_Format( wal.type , NVL(jbs.text_value,wal.text_default) , NVL(jbs.number_value,wal.number_default) , NVL(jbs.date_value,wal.date_default) , wal.format ) wf_attribute_value , jbs.text_value , jbs.number_value , jbs.date_value FROM jtf_brm_wf_attr_values jbs , ( SELECT wf1.activity_item_type , wf1.activity_name , wf1.name , wf1.display_name , wf1.description , wf1.type , wf1.format , wf1.activity_version , wf1.text_default , wf1.number_default , wf1.date_default FROM wf_activity_attributes_vl wf1 WHERE wf1.activity_version = ( SELECT MAX(wf2.activity_version) FROM wf_activity_attributes_vl wf2 WHERE wf2.activity_item_type = wf1.activity_item_type AND wf2.activity_name = wf1.activity_name ) ) wal , ( SELECT lookup_code brm_wf_item_type FROM FND_LOOKUP_VALUES WHERE lookup_type = 'JTF_BRM_WF_ITEM_TYPE' AND language = USERENV('LANG') )lit WHERE jbs.wf_item_type = wal.activity_item_type AND jbs.wf_activity_name = wal.activity_name AND jbs.wf_activity_version = wal.activity_version AND jbs.wf_activity_attribute_name = wal.name AND lit.brm_wf_item_type = wal.activity_item_type UNION ALL SELECT wal.ROWID row_id , TO_NUMBER(NULL) wf_attr_value_id , TO_NUMBER(NULL) wf_process_id , wal.activity_item_type wf_item_type , wal.activity_name wf_process_name , wal.activity_version wf_process_version , wal.name wf_attribute_name , wal.display_name wf_attribute_display_name , wal.description wf_attribute_description , wal.type wf_attribute_type , wal.format wf_attribute_format , JTF_BRM_UTILITY_PVT.Attribute_Format( wal.type , wal.text_default , wal.number_default , wal.date_default , wal.format ) wf_attribute_value , TO_CHAR(NULL) text_value , TO_NUMBER(NULL) number_value , TO_DATE(NULL) date_value FROM( SELECT wf1.activity_item_type , wf1.activity_name , wf1.name , wf1.display_name , wf1.description , wf1.type , wf1.format , wf1.activity_version , wf1.text_default , wf1.number_default , wf1.date_default FROM wf_activity_attributes_vl wf1 WHERE wf1.activity_version = ( SELECT MAX(wf2.activity_version) FROM wf_activity_attributes_vl wf2 WHERE wf2.activity_item_type = wf1.activity_item_type AND wf2.activity_name = wf1.activity_name ) ) wal , ( SELECT lookup_code brm_wf_item_type FROM FND_LOOKUP_VALUES WHERE lookup_type = 'JTF_BRM_WF_ITEM_TYPE' AND language = USERENV('LANG') )lit WHERE lit.brm_wf_item_type = wal.activity_item_type

View Text - HTML Formatted

SELECT WAL.ROWID ROW_ID
, JBS.WF_ATTR_VALUE_ID WF_ATTR_VALUE_ID
, JBS.PROCESS_ID WF_PROCESS_ID
, WAL.ACTIVITY_ITEM_TYPE WF_ITEM_TYPE
, WAL.ACTIVITY_NAME WF_PROCESS_NAME
, WAL.ACTIVITY_VERSION WF_PROCESS_VERSION
, WAL.NAME WF_ATTRIBUTE_NAME
, WAL.DISPLAY_NAME WF_ATTRIBUTE_DISPLAY_NAME
, WAL.DESCRIPTION WF_ATTRIBUTE_DESCRIPTION
, WAL.TYPE WF_ATTRIBUTE_TYPE
, WAL.FORMAT WF_ATTRIBUTE_FORMAT
, JTF_BRM_UTILITY_PVT.ATTRIBUTE_FORMAT( WAL.TYPE
, NVL(JBS.TEXT_VALUE
, WAL.TEXT_DEFAULT)
, NVL(JBS.NUMBER_VALUE
, WAL.NUMBER_DEFAULT)
, NVL(JBS.DATE_VALUE
, WAL.DATE_DEFAULT)
, WAL.FORMAT ) WF_ATTRIBUTE_VALUE
, JBS.TEXT_VALUE
, JBS.NUMBER_VALUE
, JBS.DATE_VALUE
FROM JTF_BRM_WF_ATTR_VALUES JBS
, ( SELECT WF1.ACTIVITY_ITEM_TYPE
, WF1.ACTIVITY_NAME
, WF1.NAME
, WF1.DISPLAY_NAME
, WF1.DESCRIPTION
, WF1.TYPE
, WF1.FORMAT
, WF1.ACTIVITY_VERSION
, WF1.TEXT_DEFAULT
, WF1.NUMBER_DEFAULT
, WF1.DATE_DEFAULT
FROM WF_ACTIVITY_ATTRIBUTES_VL WF1
WHERE WF1.ACTIVITY_VERSION = ( SELECT MAX(WF2.ACTIVITY_VERSION)
FROM WF_ACTIVITY_ATTRIBUTES_VL WF2
WHERE WF2.ACTIVITY_ITEM_TYPE = WF1.ACTIVITY_ITEM_TYPE
AND WF2.ACTIVITY_NAME = WF1.ACTIVITY_NAME ) ) WAL
, ( SELECT LOOKUP_CODE BRM_WF_ITEM_TYPE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'JTF_BRM_WF_ITEM_TYPE'
AND LANGUAGE = USERENV('LANG') )LIT
WHERE JBS.WF_ITEM_TYPE = WAL.ACTIVITY_ITEM_TYPE
AND JBS.WF_ACTIVITY_NAME = WAL.ACTIVITY_NAME
AND JBS.WF_ACTIVITY_VERSION = WAL.ACTIVITY_VERSION
AND JBS.WF_ACTIVITY_ATTRIBUTE_NAME = WAL.NAME
AND LIT.BRM_WF_ITEM_TYPE = WAL.ACTIVITY_ITEM_TYPE UNION ALL SELECT WAL.ROWID ROW_ID
, TO_NUMBER(NULL) WF_ATTR_VALUE_ID
, TO_NUMBER(NULL) WF_PROCESS_ID
, WAL.ACTIVITY_ITEM_TYPE WF_ITEM_TYPE
, WAL.ACTIVITY_NAME WF_PROCESS_NAME
, WAL.ACTIVITY_VERSION WF_PROCESS_VERSION
, WAL.NAME WF_ATTRIBUTE_NAME
, WAL.DISPLAY_NAME WF_ATTRIBUTE_DISPLAY_NAME
, WAL.DESCRIPTION WF_ATTRIBUTE_DESCRIPTION
, WAL.TYPE WF_ATTRIBUTE_TYPE
, WAL.FORMAT WF_ATTRIBUTE_FORMAT
, JTF_BRM_UTILITY_PVT.ATTRIBUTE_FORMAT( WAL.TYPE
, WAL.TEXT_DEFAULT
, WAL.NUMBER_DEFAULT
, WAL.DATE_DEFAULT
, WAL.FORMAT ) WF_ATTRIBUTE_VALUE
, TO_CHAR(NULL) TEXT_VALUE
, TO_NUMBER(NULL) NUMBER_VALUE
, TO_DATE(NULL) DATE_VALUE FROM( SELECT WF1.ACTIVITY_ITEM_TYPE
, WF1.ACTIVITY_NAME
, WF1.NAME
, WF1.DISPLAY_NAME
, WF1.DESCRIPTION
, WF1.TYPE
, WF1.FORMAT
, WF1.ACTIVITY_VERSION
, WF1.TEXT_DEFAULT
, WF1.NUMBER_DEFAULT
, WF1.DATE_DEFAULT
FROM WF_ACTIVITY_ATTRIBUTES_VL WF1
WHERE WF1.ACTIVITY_VERSION = ( SELECT MAX(WF2.ACTIVITY_VERSION)
FROM WF_ACTIVITY_ATTRIBUTES_VL WF2
WHERE WF2.ACTIVITY_ITEM_TYPE = WF1.ACTIVITY_ITEM_TYPE
AND WF2.ACTIVITY_NAME = WF1.ACTIVITY_NAME ) ) WAL
, ( SELECT LOOKUP_CODE BRM_WF_ITEM_TYPE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'JTF_BRM_WF_ITEM_TYPE'
AND LANGUAGE = USERENV('LANG') )LIT
WHERE LIT.BRM_WF_ITEM_TYPE = WAL.ACTIVITY_ITEM_TYPE