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 522: WF_ACTIVITIES A,

518: -- current notification
519: cursor hist0c(x_item_type varchar2, x_item_key varchar2, x_actid number) is
520: 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
521: from WF_ITEM_ACTIVITY_STATUSES IAS,
522: WF_ACTIVITIES A,
523: WF_PROCESS_ACTIVITIES PA,
524: WF_ITEM_TYPES IT,
525: WF_ITEMS I
526: where IAS.ITEM_TYPE = x_item_type

Line 541: WF_ACTIVITIES A,

537: -- past notifications
538: cursor histc(x_item_type varchar2, x_item_key varchar2, x_actid number) is
539: 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
540: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
541: WF_ACTIVITIES A,
542: WF_PROCESS_ACTIVITIES PA,
543: WF_ITEM_TYPES IT,
544: WF_ITEMS I
545: where IAS.ITEM_TYPE = x_item_type

Line 8121: WF_ACTIVITIES A,

8117: IAS.ACTIVITY_RESULT_CODE H_ACTION,
8118: '#WF_NOTE#' H_COMMENT,
8119: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
8120: from WF_ITEM_ACTIVITY_STATUSES IAS,
8121: WF_ACTIVITIES A,
8122: WF_PROCESS_ACTIVITIES PA,
8123: WF_ITEMS I
8124: where IAS.ITEM_TYPE = l_item_type
8125: and IAS.ITEM_KEY = l_item_key

Line 8149: WF_ACTIVITIES A,

8145: IAS.ACTIVITY_RESULT_CODE H_ACTION,
8146: '#WF_NOTE#' H_COMMENT,
8147: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
8148: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
8149: WF_ACTIVITIES A,
8150: WF_PROCESS_ACTIVITIES PA,
8151: WF_ITEMS I
8152: where IAS.ITEM_TYPE = l_item_type
8153: and IAS.ITEM_KEY = l_item_key

Line 9575: WF_ACTIVITIES A,

9571: begin
9572: select A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE
9573: into l_result_type, p_result_code
9574: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
9575: WF_ACTIVITIES A,
9576: WF_PROCESS_ACTIVITIES PA,
9577: WF_ITEMS I
9578: where IAS.NOTIFICATION_ID = p_nid
9579: and IAS.ITEM_TYPE = I.ITEM_TYPE

Line 9591: WF_ACTIVITIES A,

9587: when NO_DATA_FOUND then
9588: select A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE
9589: into l_result_type, p_result_code
9590: from WF_ITEM_ACTIVITY_STATUSES IAS,
9591: WF_ACTIVITIES A,
9592: WF_PROCESS_ACTIVITIES PA,
9593: WF_ITEMS I
9594: where IAS.NOTIFICATION_ID = p_nid
9595: and IAS.ITEM_TYPE = I.ITEM_TYPE