APPS.ZPB_WF dependencies on WF_ITEMS_V

Line 888: from wf_items_v

884: BEGIN
885:
886:
887: select root_activity into l_wfprocess
888: from wf_items_v
889: where item_key = ItemKey;
890:
891:
892: IF (command = 'SET_CTX') THEN

Line 977: from wf_items_v v

973: Loop
974: -- BUG 4517776 - SELECT ON WF VIEW WITHIN ZPB_WFBKGMGR SLOW
975: select count(*)
976: into itemsToProcess
977: from wf_items_v v
978: WHERE v.ITEM_TYPE = 'ZPBSCHED' AND end_date is NULL
979: AND v.item_key in (select t.item_key from WF_ITEM_ACTIVITY_STATUSES t
980: where t.item_type = 'ZPBSCHED' AND t.ACTIVITY_STATUS IN ('DEFERRED', 'NOTIFIED'));
981:

Line 992: from wf_items_v v

988:
989: -- One last look before exit
990: select count(*)
991: into itemsToProcess
992: from wf_items_v v
993: WHERE v.ITEM_TYPE = 'ZPBSCHED' AND end_date is NULL
994: AND v.item_key in (select t.item_key from WF_ITEM_ACTIVITY_STATUSES t
995: where t.item_type = 'ZPBSCHED' AND t.ACTIVITY_STATUS IN ('DEFERRED', 'NOTIFIED'));
996:

Line 1042: from wf_items_v v

1038: Loop
1039: -- BUG 4517776 - SELECT ON WF VIEW WITHIN ZPB_WFBKGMGR SLOW
1040: select count(*)
1041: into itemsToProcess
1042: from wf_items_v v
1043: WHERE v.ITEM_TYPE = 'EPBCYCLE' AND end_date is NULL
1044: AND v.item_key in (select t.item_key from WF_ITEM_ACTIVITY_STATUSES t
1045: where t.item_type = 'EPBCYCLE' AND t.ACTIVITY_STATUS IN ('DEFERRED', 'NOTIFIED'));
1046:

Line 1056: from wf_items_v v

1052: dbms_lock.sleep(seconds);
1053: -- One last look before exit
1054: select count(*)
1055: into itemsToProcess
1056: from wf_items_v v
1057: WHERE v.ITEM_TYPE = 'EPBCYCLE' AND end_date is NULL
1058: AND v.item_key in (select t.item_key from WF_ITEM_ACTIVITY_STATUSES t
1059: where t.item_type = 'EPBCYCLE' AND t.ACTIVITY_STATUS IN ('DEFERRED', 'NOTIFIED'));
1060:

Line 1355: select ITEM_TYPE into ItemType from WF_ITEMS_V

1351:
1352: -- set workflow with Instance Cycle ID!
1353: -- This will be respective to the Scheduler or and Event Task
1354: -- GET the correct ITEMTYPE for this run
1355: select ITEM_TYPE into ItemType from WF_ITEMS_V
1356: where item_key = ItemKey;
1357:
1358: wf_engine.SetItemAttrNumber(Itemtype => ItemType,
1359: Itemkey => ItemKey,

Line 4814: from wf_items_v

4810:
4811:
4812: select root_activity
4813: into l_wfprocess
4814: from wf_items_v
4815: where item_type = itemtype
4816: and item_KEY = itemkey;
4817:
4818: