APPS.MSC_WS_COLLECTIONS SQL Statements

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

Line: 669

           STATUS := 'INVALID_ORDER_TYPE_SELECTION';

Line: 1107

           STATUS := 'INVALID_SELECTION_CURRENCY_LIST';

Line: 1240

           STATUS := 'INVALID_SELECTION_UOM_LIST';

Line: 1390

           STATUS := 'INVALID_SELECTION_PRICE_LIST';

Line: 1656

     SELECT to_number(decode(CollectionMethod,'COMPLETE_REFRESH',1,'NET_CHANGE_REFRESH',2,'TARGETED_REFRESH',3, -1))
     INTO cCode FROM dual;

Line: 1670

     SELECT to_number(decode(ApprovedSupplierList,'YES_REPLACE',1,'NO',2,'YES_BUT_RETAIN_CP', 3,-1))
     INTO cCode FROM dual;

Line: 1683

     SELECT to_number(decode(UserCompanyAssoc,'CREATE_USERS_ENABLE_UCA',3,'NO',1,'ENABLE_UCA', 2,-1))
     INTO cCode FROM dual;

Line: 1696

     SELECT to_number(decode(ResourceAvailability,'COLLECT_DATA',1,'DO_NOT_COLLECT_DATA',2,'REGENERATE_DATA', 3,-1))
     INTO cCode FROM dual;

Line: 1710

        SELECT instance_id INTO l_val_instance_id
        FROM   msc_apps_instances
        WHERE  instance_id = INST_ID
        AND    instance_type IN (1,2,4) and enable_flag=1;

Line: 1730

        SELECT org_group into cCode
        from MSC_ORG_GROUPS_V
        WHERE code = orgGroup
        and (instance_id IS NULL OR instance_id = InstanceId);

Line: 1751

        SELECT org_group into cCode
        from MSD_DEM_ORG_GROUPS_V
        WHERE code = orgGroup
        and (instance_id IS NULL OR instance_id = InstanceId);

Line: 1772

        SELECT lookup_code INTO cCode
        FROM fnd_lookup_values_vl flv
        WHERE flv.lookup_type = 'MSD_DEM_COLL_METHODS'
        AND flv.lookup_code = methodCode;

Line: 1798

       SELECT lookup_code into cCode from fnd_lookup_values_vl flv
       WHERE flv.lookup_type = 'MSD_DEM_DATE_RANGE_TYPES'
       --AND '1' = hiddenParam
       AND lookup_code= dateRangeType;

Line: 1874

    SELECT msd_dem_common_utilities.get_lookup_value ('MSD_DEM_DM_STAGING_TABLES', 'SALES_STAGING_TABLE') into value from dual;

Line: 1882

     SELECT to_number(decode(CollectionMethod,'COMPLETE',1,'NET_CHANGE',2, -1))
     INTO cCode FROM dual;

Line: 1891

     SELECT to_number(decode(DateRangeType,'ABSOLUTE',1,'ROLLING',2, -1))
     INTO cCode FROM dual;

Line: 1902

selectStr varchar2(1555);

Line: 1910

    select a2m_dblink into dbLink
    from msc_apps_instances
    where instance_id = InstanceId;

Line: 1914

    select DECODE(dbLink, NULL,'', '@' || dbLink) into dbLink2 from dual;

Line: 1921

        selectStr :=  'SELECT count(1)
                       FROM ' || tableName || ' a, ' || tableNameAll || ' b
                       WHERE b.transaction_type_code =''LINE''
                       AND b.order_category_code = ''RETURN''
                       AND a.LANGUAGE = userenv(''LANG'')
                       AND a.transaction_type_id = b.transaction_type_id
                       AND a.name = ''' ||types(i) || '''';

Line: 1931

        execute immediate selectStr into v_number;

Line: 1954

        INSERT INTO MSD_DEM_RMA_TYPE
            ( RMA_TYPES )
        VALUES
            (
            RMATypes(i)
            );