DBA Data[Home] [Help]

APPS.WF_QUEUE dependencies on WF_ITEMS

Line 841: WF_ITEMS WI,

837: SELECT CWA.COST, CWIAS.BEGIN_DATE
838: into cost, l_begdate
839: FROM WF_ITEM_ACTIVITY_STATUSES CWIAS,
840: WF_PROCESS_ACTIVITIES CWPA,
841: WF_ITEMS WI,
842: WF_ACTIVITIES CWA
843: where CWIAS.ACTIVITY_STATUS = 'DEFERRED'
844: and CWIAS.PROCESS_ACTIVITY = CWPA.INSTANCE_ID
845: and CWPA.ACTIVITY_ITEM_TYPE = CWA.ITEM_TYPE