DBA Data[Home] [Help]

VIEW: APPS.JTS_SETUP_FLOWS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.flow_id, T.flow_name, B.flow_code, B.flow_type, B.parent_id, B.has_child_flag, B.flow_sequence, B.overview_url, B.diagnostics_url, B.dpf_code, B.dpf_asn, B.num_steps, B.object_version_number, B.creation_date, B.created_by, B.last_update_date, B.last_updated_by, B.last_update_login FROM jts_setup_flows_tl T, jts_setup_flows_b B WHERE B.flow_id = T.flow_id AND T.LANGUAGE = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.FLOW_ID
, T.FLOW_NAME
, B.FLOW_CODE
, B.FLOW_TYPE
, B.PARENT_ID
, B.HAS_CHILD_FLAG
, B.FLOW_SEQUENCE
, B.OVERVIEW_URL
, B.DIAGNOSTICS_URL
, B.DPF_CODE
, B.DPF_ASN
, B.NUM_STEPS
, B.OBJECT_VERSION_NUMBER
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM JTS_SETUP_FLOWS_TL T
, JTS_SETUP_FLOWS_B B
WHERE B.FLOW_ID = T.FLOW_ID
AND T.LANGUAGE = USERENV('LANG')