APPS.WIP_DISCRETE_INIT SQL Statements

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

Line: 149

                SELECT wp.DEFAULT_DISCRETE_CLASS,
                       wp.LOT_NUMBER_DEFAULT_TYPE,
                       wp.PO_CREATION_TIME,
                       wp.default_serialization_start_op,
                       wp.propagate_job_change_to_po
                FROM   WIP_PARAMETERS wp
                WHERE  wp.ORGANIZATION_ID = p_organization_id;

Line: 157

                SELECT DECODE(count(*),0,0,1)
                FROM   WIP_STANDARD_CLASSES_VAL_V wac
                WHERE  wac.ORGANIZATION_ID = p_organization_id;

Line: 161

                SELECT  DECODE(count(*),0,0,2)
                FROM    WIP_NON_STANDARD_CLASSES_VAL_V wac
                WHERE   wac.ORGANIZATION_ID = p_organization_id;

Line: 165

                SELECT  NVL(DISABLE_DATE,SYSDATE+1),
                        MATERIAL_ACCOUNT,
                        MATERIAL_VARIANCE_ACCOUNT,
                        MATERIAL_OVERHEAD_ACCOUNT,
                        RESOURCE_ACCOUNT,
                        RESOURCE_VARIANCE_ACCOUNT,
                        OUTSIDE_PROCESSING_ACCOUNT,
                        OUTSIDE_PROC_VARIANCE_ACCOUNT,
                        OVERHEAD_ACCOUNT,
                        OVERHEAD_VARIANCE_ACCOUNT,
                        STD_COST_ADJUSTMENT_ACCOUNT
                FROM    WIP_ACCOUNTING_CLASSES wac
                WHERE   wac.ORGANIZATION_ID = p_organization_id
                AND     wac.CLASS_CODE = cc;

Line: 180

                SELECT  max(STOCK_LOCATOR_CONTROL_CODE),
                        max(DEFAULT_DEMAND_CLASS),
                        max(CALENDAR_CODE),
                        max(CALENDAR_EXCEPTION_SET_ID),
                        nvl(max(PROJECT_REFERENCE_ENABLED),2),
                        nvl(max(PROJECT_CONTROL_LEVEL),1),
                        nvl(max(PM_COST_COLLECTION_ENABLED),2),
                        max(PRIMARY_COST_METHOD)
                FROM    MTL_PARAMETERS
                WHERE   ORGANIZATION_ID = p_organization_id;