DBA Data[Home] [Help]

APPS.PQH_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1463: WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS

1459: cursor c1 is
1460: SELECT A.NAME activity_name,
1461: wf_directory.getroledisplayname(IAS.ASSIGNED_USER) role_name ,IAS.ASSIGNED_USER owner
1462: from WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,
1463: WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS
1464: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE
1465: and IAS.ITEM_KEY = I.ITEM_KEY
1466: and I.BEGIN_DATE between A.BEGIN_DATE and nvl(A.END_DATE, I.BEGIN_DATE)
1467: and I.ITEM_TYPE = IT.NAME