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.

APPS.WF_NOTIFICATION dependencies on WF_PROCESS_ACTIVITIES

Line 528: WF_PROCESS_ACTIVITIES PA,

524: cursor hist0c(x_item_type varchar2, x_item_key varchar2, x_actid number) is
525: select IAS.NOTIFICATION_ID, IAS.ASSIGNED_USER, A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE, nvl(IAS.END_DATE, IAS.BEGIN_DATE) ACT_DATE, IAS.EXECUTION_TIME
526: from WF_ITEM_ACTIVITY_STATUSES IAS,
527: WF_ACTIVITIES A,
528: WF_PROCESS_ACTIVITIES PA,
529: WF_ITEM_TYPES IT,
530: WF_ITEMS I
531: where IAS.ITEM_TYPE = x_item_type
532: and IAS.ITEM_KEY = x_item_key

Line 547: WF_PROCESS_ACTIVITIES PA,

543: cursor histc(x_item_type varchar2, x_item_key varchar2, x_actid number) is
544: select IAS.NOTIFICATION_ID, IAS.ASSIGNED_USER, A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE, nvl(IAS.END_DATE, IAS.BEGIN_DATE) ACT_DATE, IAS.EXECUTION_TIME
545: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
546: WF_ACTIVITIES A,
547: WF_PROCESS_ACTIVITIES PA,
548: WF_ITEM_TYPES IT,
549: WF_ITEMS I
550: where IAS.ITEM_TYPE = x_item_type
551: and IAS.ITEM_KEY = x_item_key

Line 7896: WF_PROCESS_ACTIVITIES PA,

7892: '#WF_NOTE#' H_COMMENT,
7893: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
7894: from WF_ITEM_ACTIVITY_STATUSES IAS,
7895: WF_ACTIVITIES A,
7896: WF_PROCESS_ACTIVITIES PA,
7897: WF_ITEMS I
7898: where IAS.ITEM_TYPE = l_item_type
7899: and IAS.ITEM_KEY = l_item_key
7900: and IAS.PROCESS_ACTIVITY = l_actid

Line 7924: WF_PROCESS_ACTIVITIES PA,

7920: '#WF_NOTE#' H_COMMENT,
7921: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
7922: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
7923: WF_ACTIVITIES A,
7924: WF_PROCESS_ACTIVITIES PA,
7925: WF_ITEMS I
7926: where IAS.ITEM_TYPE = l_item_type
7927: and IAS.ITEM_KEY = l_item_key
7928: and IAS.PROCESS_ACTIVITY = l_actid

Line 9328: WF_PROCESS_ACTIVITIES PA,

9324: select A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE
9325: into l_result_type, p_result_code
9326: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
9327: WF_ACTIVITIES A,
9328: WF_PROCESS_ACTIVITIES PA,
9329: WF_ITEMS I
9330: where IAS.NOTIFICATION_ID = p_nid
9331: and IAS.ITEM_TYPE = I.ITEM_TYPE
9332: and IAS.ITEM_KEY = I.ITEM_KEY

Line 9344: WF_PROCESS_ACTIVITIES PA,

9340: select A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE
9341: into l_result_type, p_result_code
9342: from WF_ITEM_ACTIVITY_STATUSES IAS,
9343: WF_ACTIVITIES A,
9344: WF_PROCESS_ACTIVITIES PA,
9345: WF_ITEMS I
9346: where IAS.NOTIFICATION_ID = p_nid
9347: and IAS.ITEM_TYPE = I.ITEM_TYPE
9348: and IAS.ITEM_KEY = I.ITEM_KEY