APPS.WSMPLCVA SQL Statements

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

Line: 15

select  wsm.ORGANIZATION_ID,
        wsm.COPRODUCTS_SUPPLY_DEFAULT,
        wsm.DEFAULT_ACCT_CLASS_CODE,
        wsm.OP_SEQ_NUM_INCREMENT,
        wsm.LAST_OPERATION_SEQ_NUM,
        wsm.ESTIMATED_SCRAP_ACCOUNTING,
        NULL,
        NULL,
        wp.po_creation_time
--from  MTL_PARAMETERS MP , WSM_PARAMETERS WSM, ORG_ORGANIZATION_DEFINITIONS ORG
from    MTL_PARAMETERS MP , WSM_PARAMETERS WSM, HR_ALL_ORGANIZATION_UNITS ORG, WIP_PARAMETERS WP
where   MP.ORGANIZATION_ID =  WSM.ORGANIZATION_ID
and     ORG.ORGANIZATION_ID =  WSM.ORGANIZATION_ID
and     WP.ORGANIZATION_ID =  WSM.ORGANIZATION_ID
and     UPPER(MP.WSM_ENABLED_FLAG)='Y'
and     TRUNC(SYSDATE) <= NVL(ORG.DATE_TO, SYSDATE+1);

Line: 64

        SELECT max(stock_locator_control_code)
        INTO  v_org(v_index).MAX_STK_LOC_CNTRL
        FROM  mtl_parameters
        WHERE organization_id = v_index;

Line: 85

    select  organization_id,
            class_code
    from    wip_accounting_classes
    where   nvl(disable_date, sysdate+2) > sysdate
    and     class_type = 5 ;

Line: 128

    select  organization_id,
            secondary_inventory_name
    from    wsm_subinventory_extensions;