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.OE_RMA_GRP dependencies on WF_PROCESS_ACTIVITIES

Line 326: from WF_PROCESS_ACTIVITIES PA,

322: SELECT wv.NOTIFICATION_ID
323: FROM
324: (
325: select IAS.NOTIFICATION_ID NOTIFICATION_ID, IAS.END_DATE END_DATE
326: from WF_PROCESS_ACTIVITIES PA,
327: WF_ITEM_ACTIVITY_STATUSES IAS
328: where IAS.ITEM_TYPE = itemtype
329: and IAS.ITEM_KEY = itemkey
330: and PA.ACTIVITY_NAME = 'RMA_ORDER_APPROVAL_NTF'

Line 335: from WF_PROCESS_ACTIVITIES PA,

331: and IAS.NOTIFICATION_ID is not null
332: and IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
333: UNION ALL
334: select IAS.NOTIFICATION_ID, IAS.END_DATE
335: from WF_PROCESS_ACTIVITIES PA,
336: WF_ITEM_ACTIVITY_STATUSES_H IAS
337: where IAS.ITEM_TYPE = itemtype
338: and IAS.ITEM_KEY = itemkey
339: and PA.ACTIVITY_NAME = 'RMA_ORDER_APPROVAL_NTF'

Line 494: from WF_PROCESS_ACTIVITIES PA,

490: SELECT wv.NOTIFICATION_ID
491: FROM
492: (
493: select IAS.NOTIFICATION_ID NOTIFICATION_ID, IAS.END_DATE END_DATE
494: from WF_PROCESS_ACTIVITIES PA,
495: WF_ITEM_ACTIVITY_STATUSES IAS
496: where IAS.ITEM_TYPE = itemtype
497: and IAS.ITEM_KEY = itemkey
498: and PA.ACTIVITY_NAME = 'RMA_ORDER_APPROVAL_NTF'

Line 503: from WF_PROCESS_ACTIVITIES PA,

499: and IAS.NOTIFICATION_ID is not null
500: and IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
501: UNION ALL
502: select IAS.NOTIFICATION_ID, IAS.END_DATE
503: from WF_PROCESS_ACTIVITIES PA,
504: WF_ITEM_ACTIVITY_STATUSES_H IAS
505: where IAS.ITEM_TYPE = itemtype
506: and IAS.ITEM_KEY = itemkey
507: and PA.ACTIVITY_NAME = 'RMA_ORDER_APPROVAL_NTF'