DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on WF_ITEM_TYPES

Line 3516: ,WF_ITEM_TYPES IT

3512: FROM wf_item_activity_statuses ias
3513: ,wf_activities a
3514: ,wf_process_activities pa
3515: ,wf_items i
3516: ,WF_ITEM_TYPES IT
3517: where IAS.ITEM_TYPE = 'HRSSA'
3518: and IAS.ITEM_KEY = '15018'
3519: and IAS.NOTIFICATION_ID is not null
3520: and nvl(RESULT_TYPE,'*') NOT IN ( '*','HR_DONE')

Line 3549: ,WF_ITEM_TYPES IT

3545: FROM wf_item_activity_statuses_h ias
3546: ,wf_activities a
3547: ,wf_process_activities pa
3548: ,wf_items i
3549: ,WF_ITEM_TYPES IT
3550: where IAS.ITEM_TYPE = 'HRSSA'
3551: and IAS.ITEM_KEY = '15018'
3552: and IAS.NOTIFICATION_ID is not null
3553: and (IAS.ACTIVITY_RESULT_CODE is null or IAS.ACTIVITY_RESULT_CODE not in ('SFL','#NULL'))