eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.AMW_HIERARCHY_ENTITIES_V

Source

View Text - Preformatted


SELECT amwp.Process_Rev_Id Process_Rev_Id, wa_TL.Display_NAME Process_Display_Name, amwp.process_id Process_Id, amwp.name name, amwp.item_type item_type, amwp.significant_process_flag SIGNIFICANT_PROCESS_FLAG, amwp.STANDARD_PROCESS_FLAG STANDARD_PROCESS_FLAG, amwp.APPROVAL_STATUS APPROVAL_STATUS, decode (amwp.process_id, -1, to_number(null), amwp.risk_count) RISK_COUNT, decode (amwp.process_id, -1, to_number(null), amwp.control_count) CONTROL_COUNT, decode (amwp.process_id, -1, to_number(null), amwp.org_count) ORG_COUNT, amwp.process_owner_id PROCESS_OWNER_ID, hzp1.party_name process_owner_name, amwp.certification_status Certification_Status_Code, AMW_Utility_PVT.get_lookup_meaning('AMW_CERTIFICATION_STATUS',amwp.certification_status) Certification_Status, AMW_Utility_PVT.get_lookup_meaning('AMW_PROCESS_APPROVAL_STATUS',amwp.APPROVAL_STATUS) Approval_Status_Meaning, amwp.application_owner_id Application_Owner_Id, hzp2.party_name Application_Owner_Name, amwp.process_category Process_Category, AMW_Utility_PVT.get_lookup_meaning('AMW_PROCESS_CATEGORY',amwp.process_category) Process_Category_Meaning, decode (amwp.process_id, -1, null, 'OA.jsp?OAFunc=AMW_PROCESS_DETAILS&processId='||amwp.process_id||'&processRevId='||amwp.Process_Rev_Id||'&pObjectContext=PROCESS&addBreadCrumb=Y&retainAM=Y') URLString, amwp.finance_owner_id finance_owner_id, hzp3.party_name finance_owner_name, decode (amwp.process_id, -1, null, 'OAFunc=AMW_PROCESS_DETAILS&processId='||amwp.process_id||'&processRevId='||amwp.Process_Rev_Id||'&pObjectContext=PROCESS&GoToTab=R&addBreadCrumb=Y&retainAM=Y') RiskCntURL, decode (amwp.process_id, -1, null, 'OAFunc=AMW_PROCESS_DETAILS&processId='||amwp.process_id||'&processRevId='||amwp.Process_Rev_Id||'&pObjectContext=PROCESS&GoToTab=C&addBreadCrumb=Y&retainAM=Y') CtrlCntURL, decode (amwp.process_id, -1, null, 'OAFunc=AMW_PROCESS_DETAILS&processId='||amwp.process_id||'&processRevId='||amwp.Process_Rev_Id||'&pObjectContext=PROCESS&GoToTab=O&addBreadCrumb=Y&retainAM=Y') OrgCntURL, amwp.standard_variation Standard_Variation from amw_process amwp, wf_activities wa, WF_ACTIVITIES_TL wa_TL, hz_parties hzp1, hz_parties hzp2, hz_parties hzp3 WHERE amwp.name = wa.name and amwp.item_type = wa.item_type and wa.end_date is null and wa_TL.name = wa.NAME and wa_TL.version = wa.version and wa_TL.item_type = wa.item_type and wa_TL.language = userenv('LANG') and hzp1.party_id (+) = amwp.process_owner_id and hzp2.party_id (+) = amwp.application_owner_id and hzp3.party_id (+) = amwp.finance_owner_id

View Text - HTML Formatted

SELECT AMWP.PROCESS_REV_ID PROCESS_REV_ID
, WA_TL.DISPLAY_NAME PROCESS_DISPLAY_NAME
, AMWP.PROCESS_ID PROCESS_ID
, AMWP.NAME NAME
, AMWP.ITEM_TYPE ITEM_TYPE
, AMWP.SIGNIFICANT_PROCESS_FLAG SIGNIFICANT_PROCESS_FLAG
, AMWP.STANDARD_PROCESS_FLAG STANDARD_PROCESS_FLAG
, AMWP.APPROVAL_STATUS APPROVAL_STATUS
, DECODE (AMWP.PROCESS_ID
, -1
, TO_NUMBER(NULL)
, AMWP.RISK_COUNT) RISK_COUNT
, DECODE (AMWP.PROCESS_ID
, -1
, TO_NUMBER(NULL)
, AMWP.CONTROL_COUNT) CONTROL_COUNT
, DECODE (AMWP.PROCESS_ID
, -1
, TO_NUMBER(NULL)
, AMWP.ORG_COUNT) ORG_COUNT
, AMWP.PROCESS_OWNER_ID PROCESS_OWNER_ID
, HZP1.PARTY_NAME PROCESS_OWNER_NAME
, AMWP.CERTIFICATION_STATUS CERTIFICATION_STATUS_CODE
, AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_CERTIFICATION_STATUS'
, AMWP.CERTIFICATION_STATUS) CERTIFICATION_STATUS
, AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_PROCESS_APPROVAL_STATUS'
, AMWP.APPROVAL_STATUS) APPROVAL_STATUS_MEANING
, AMWP.APPLICATION_OWNER_ID APPLICATION_OWNER_ID
, HZP2.PARTY_NAME APPLICATION_OWNER_NAME
, AMWP.PROCESS_CATEGORY PROCESS_CATEGORY
, AMW_UTILITY_PVT.GET_LOOKUP_MEANING('AMW_PROCESS_CATEGORY'
, AMWP.PROCESS_CATEGORY) PROCESS_CATEGORY_MEANING
, DECODE (AMWP.PROCESS_ID
, -1
, NULL
, 'OA.JSP?OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||AMWP.PROCESS_ID||'&PROCESSREVID='||AMWP.PROCESS_REV_ID||'&POBJECTCONTEXT=PROCESS&ADDBREADCRUMB=Y&RETAINAM=Y') URLSTRING
, AMWP.FINANCE_OWNER_ID FINANCE_OWNER_ID
, HZP3.PARTY_NAME FINANCE_OWNER_NAME
, DECODE (AMWP.PROCESS_ID
, -1
, NULL
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||AMWP.PROCESS_ID||'&PROCESSREVID='||AMWP.PROCESS_REV_ID||'&POBJECTCONTEXT=PROCESS&GOTOTAB=R&ADDBREADCRUMB=Y&RETAINAM=Y') RISKCNTURL
, DECODE (AMWP.PROCESS_ID
, -1
, NULL
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||AMWP.PROCESS_ID||'&PROCESSREVID='||AMWP.PROCESS_REV_ID||'&POBJECTCONTEXT=PROCESS&GOTOTAB=C&ADDBREADCRUMB=Y&RETAINAM=Y') CTRLCNTURL
, DECODE (AMWP.PROCESS_ID
, -1
, NULL
, 'OAFUNC=AMW_PROCESS_DETAILS&PROCESSID='||AMWP.PROCESS_ID||'&PROCESSREVID='||AMWP.PROCESS_REV_ID||'&POBJECTCONTEXT=PROCESS&GOTOTAB=O&ADDBREADCRUMB=Y&RETAINAM=Y') ORGCNTURL
, AMWP.STANDARD_VARIATION STANDARD_VARIATION
FROM AMW_PROCESS AMWP
, WF_ACTIVITIES WA
, WF_ACTIVITIES_TL WA_TL
, HZ_PARTIES HZP1
, HZ_PARTIES HZP2
, HZ_PARTIES HZP3
WHERE AMWP.NAME = WA.NAME
AND AMWP.ITEM_TYPE = WA.ITEM_TYPE
AND WA.END_DATE IS NULL
AND WA_TL.NAME = WA.NAME
AND WA_TL.VERSION = WA.VERSION
AND WA_TL.ITEM_TYPE = WA.ITEM_TYPE
AND WA_TL.LANGUAGE = USERENV('LANG')
AND HZP1.PARTY_ID (+) = AMWP.PROCESS_OWNER_ID
AND HZP2.PARTY_ID (+) = AMWP.APPLICATION_OWNER_ID
AND HZP3.PARTY_ID (+) = AMWP.FINANCE_OWNER_ID