The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
SELECT DECODE(count(*),0,0,1)
FROM WIP_STANDARD_CLASSES_VAL_V wac
WHERE wac.ORGANIZATION_ID = p_organization_id;
SELECT DECODE(count(*),0,0,2)
FROM WIP_NON_STANDARD_CLASSES_VAL_V wac
WHERE wac.ORGANIZATION_ID = p_organization_id;
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;
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;