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_ACTIVITIES

Line 527: WF_ACTIVITIES A,

523: -- current notification
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

Line 546: WF_ACTIVITIES A,

542: -- past notifications
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

Line 7895: WF_ACTIVITIES A,

7891: IAS.ACTIVITY_RESULT_CODE H_ACTION,
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

Line 7923: WF_ACTIVITIES A,

7919: IAS.ACTIVITY_RESULT_CODE H_ACTION,
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

Line 9327: WF_ACTIVITIES A,

9323: begin
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

Line 9343: WF_ACTIVITIES A,

9339: when NO_DATA_FOUND then
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