APPS.WF_ENGINE_RAC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

    SELECT 'TRUE'
    into l_partitioned
    FROM DUAL
    WHERE 4=(select count(1)
             from dba_tab_partitions
             where table_owner=l_applsys and
                   table_name in ('WF_ITEMS',
                                  'WF_ITEM_ATTRIBUTE_VALUES',
                                  'WF_ITEM_ACTIVITY_STATUSES',
                                  'WF_ITEM_ACTIVITY_STATUSES_H')
             and partition_name='INST_ID1');

Line: 72

    select count(1) into l_dummy
    from (select null
    from FND_LOOKUP_VALUES_VL
    where LOOKUP_TYPE='WF_RAC_ENABLED_TYPES'
      and ENABLED_FLAG='Y'
      and (p_itemtype is null OR substr(LOOKUP_CODE,1, instr(LOOKUP_CODE,':',1)-1)=p_itemtype));

Line: 95

    select count(1) into l_dummy
    from (select null
    from FND_LOOKUP_VALUES_VL
    where LOOKUP_TYPE='WF_RAC_ENABLED_TYPES'
      and ENABLED_FLAG='Y'
      and LOOKUP_CODE=l_string);

Line: 114

    select count(1) into l_num_partitions
    from dba_tab_partitions
    where table_name='WF_ITEMS' and
      table_owner=wf_core.translate('WF_SCHEMA');

Line: 150

      select WITV.NAME
        from WF_ITEM_TYPES_VL WITV,
             (select unique(substr(LOOKUP_CODE,1, instr(LOOKUP_CODE,':',1)-1)) L_CODE
        from FND_LOOKUP_VALUES_VL
        where LOOKUP_TYPE='WF_RAC_ENABLED_TYPES'
        and ENABLED_FLAG='Y') WFRAC
      where WITV.NAME=WFRAC.L_CODE
        and (itemtype is null or WITV.NAME=itemtype);