[Home] [Help]
APPS.AMS_TCOP_SCHEDULER_PKG dependencies on WF_ITEMS
Line 126: FROM AMS_TCOP_REQUESTS TCOP,WF_ITEMS WF
122: IS
123: SELECT TCOP.WF_ITEM_TYPE WF_ITEM_TYPE,
124: TCOP.WF_ITEM_ID WF_ITEM_ID,
125: TCOP.SCHEDULE_ID SCHEDULE_ID
126: FROM AMS_TCOP_REQUESTS TCOP,WF_ITEMS WF
127: WHERE TCOP.STATUS='NEW'
128: and TCOP.WF_ITEM_ID=WF.ITEM_KEY
129: ORDER BY TCOP.REQUEST_DATE; --first come,first serve
130: