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_ITEM_ACTIVITY_STATUSES

Line 327: WF_ITEM_ACTIVITY_STATUSES IAS

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'
331: and IAS.NOTIFICATION_ID is not null

Line 336: WF_ITEM_ACTIVITY_STATUSES_H IAS

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'
340: and IAS.NOTIFICATION_ID is not null

Line 495: WF_ITEM_ACTIVITY_STATUSES IAS

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'
499: and IAS.NOTIFICATION_ID is not null

Line 504: WF_ITEM_ACTIVITY_STATUSES_H IAS

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'
508: and IAS.NOTIFICATION_ID is not null