DBA Data[Home] [Help]

APPS.OE_RMA_GRP dependencies on WF_ITEM_ACTIVITY_STATUSES_H

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 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