DBA Data[Home] [Help]

APPS.IBC_CITEM_WORKFLOW_PVT dependencies on WF_LOOKUPS

Line 2646: from WF_LOOKUPS L_AT, WF_LOOKUPS L_AS, WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,

2642: CURSOR c_item_approvals_nonotif(p_directory_node_id NUMBER,
2643: p_user_pattern VARCHAR2)
2644: IS
2645: select IAS.ITEM_KEY
2646: from WF_LOOKUPS L_AT, WF_LOOKUPS L_AS, WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,
2647: WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS,
2648: ibc_citem_versions_b civb,
2649: ibc_content_items citem
2650: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE

Line 2670: from WF_LOOKUPS L_AT, WF_LOOKUPS L_AS, WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,

2666: AND IAS.ACTIVITY_STATUS = 'NOTIFIED'
2667: GROUP BY IAS.ITEM_KEY
2668: MINUS
2669: select IAS.ITEM_KEY
2670: from WF_LOOKUPS L_AT, WF_LOOKUPS L_AS, WF_ACTIVITIES_VL A, WF_PROCESS_ACTIVITIES PA,
2671: WF_ITEM_TYPES_VL IT, WF_ITEMS I, WF_ITEM_ACTIVITY_STATUSES IAS, WF_USER_ROLES U,
2672: ibc_citem_versions_b civb,
2673: ibc_content_items citem
2674: WHERE IAS.ITEM_TYPE = I.ITEM_TYPE