VIEW: APPS.AMW_PROCESS_BASICINFO_V

Source

View Text - Preformatted

SELECT ap.name name,wat.display_name display_name, ap.process_category,ap.item_type,wat.version,ap.significant_process_flag, ap.standard_process_flag, ap.approval_status,ap.certification_status,ap.process_owner_id,ap.process_id, ap.last_update_date,ap.last_updated_by,ap.creation_date,ap.created_by, ap.last_update_login,ap.created_from,ap.request_id,ap.program_application_id, ap.program_id,ap.program_update_date,ap.attribute_category,ap.attribute1,ap.attribute2, ap.attribute3,ap.attribute4,ap.attribute5,ap.attribute6,ap.attribute7,ap.attribute8,ap.attribute9, ap.attribute10,ap.attribute11,ap.attribute12,ap.attribute13,ap.attribute14,ap.attribute15, ap.security_group_id,ap.object_version_number,ap.control_count,ap.risk_count , ap.finance_owner_id,ap.application_owner_id from amw_process ap, wf_activities wa,wf_activities_tl wat WHERE ap.name=wa.name and ap.item_type=wa.item_type and wa.end_date is null and wat.name=wa.name and wat.version=wa.version and wat.item_type=wa.item_type and wat.language=userenv('LANG')

View Text - HTML Formatted

SELECT AP.NAME NAME
, WAT.DISPLAY_NAME DISPLAY_NAME
, AP.PROCESS_CATEGORY
, AP.ITEM_TYPE
, WAT.VERSION
, AP.SIGNIFICANT_PROCESS_FLAG
, AP.STANDARD_PROCESS_FLAG
, AP.APPROVAL_STATUS
, AP.CERTIFICATION_STATUS
, AP.PROCESS_OWNER_ID
, AP.PROCESS_ID
, AP.LAST_UPDATE_DATE
, AP.LAST_UPDATED_BY
, AP.CREATION_DATE
, AP.CREATED_BY
, AP.LAST_UPDATE_LOGIN
, AP.CREATED_FROM
, AP.REQUEST_ID
, AP.PROGRAM_APPLICATION_ID
, AP.PROGRAM_ID
, AP.PROGRAM_UPDATE_DATE
, AP.ATTRIBUTE_CATEGORY
, AP.ATTRIBUTE1
, AP.ATTRIBUTE2
, AP.ATTRIBUTE3
, AP.ATTRIBUTE4
, AP.ATTRIBUTE5
, AP.ATTRIBUTE6
, AP.ATTRIBUTE7
, AP.ATTRIBUTE8
, AP.ATTRIBUTE9
, AP.ATTRIBUTE10
, AP.ATTRIBUTE11
, AP.ATTRIBUTE12
, AP.ATTRIBUTE13
, AP.ATTRIBUTE14
, AP.ATTRIBUTE15
, AP.SECURITY_GROUP_ID
, AP.OBJECT_VERSION_NUMBER
, AP.CONTROL_COUNT
, AP.RISK_COUNT
, AP.FINANCE_OWNER_ID
, AP.APPLICATION_OWNER_ID
FROM AMW_PROCESS AP
, WF_ACTIVITIES WA
, WF_ACTIVITIES_TL WAT
WHERE AP.NAME=WA.NAME
AND AP.ITEM_TYPE=WA.ITEM_TYPE
AND WA.END_DATE IS NULL
AND WAT.NAME=WA.NAME
AND WAT.VERSION=WA.VERSION
AND WAT.ITEM_TYPE=WA.ITEM_TYPE
AND WAT.LANGUAGE=USERENV('LANG')