QA_INSPECTION_LEVELS_VL

Details

• Schema: FUSION

• Object owner: QA

• Object type: VIEW

Columns

Name
INSPECTION_LEVEL_ID OBJECT_VERSION_NUMBER SAMPLING_ENABLED_FLAG PERCENT_SAMPLING SKIPLOT_ENABLED_FLAG NUM_LOTS NUM_LOTS_INSPECT SAMPLING_PLAN_TYPE SAMPLING_STD_CODE INSPECTION_LEVEL_CODE ACCEPTANCE_QUALITY_LIMIT FIXED_SAMPLING_COUNT QUANTITY_PER_SAMPLE SAMPLE_UOM_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN NAME DESCRIPTION

Query

SQL_Statement

SELECT qilb.INSPECTION_LEVEL_ID INSPECTION_LEVEL_ID, qilb.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, qilb.SAMPLING_ENABLED_FLAG SAMPLING_ENABLED_FLAG, qilb.PERCENT_SAMPLING PERCENT_SAMPLING, qilb.SKIPLOT_ENABLED_FLAG SKIPLOT_ENABLED_FLAG, qilb.NUM_LOTS NUM_LOTS, qilb.NUM_LOTS_INSPECT NUM_LOTS_INSPECT, qilb.SAMPLING_PLAN_TYPE, qilb.SAMPLING_STD_CODE, qilb.INSPECTION_LEVEL_CODE, qilb.ACCEPTANCE_QUALITY_LIMIT, qilb.FIXED_SAMPLING_COUNT, qilb.QUANTITY_PER_SAMPLE, qilb.SAMPLE_UOM_CODE, qilb.CREATED_BY CREATED_BY, qilb.CREATION_DATE CREATION_DATE, qilb.LAST_UPDATED_BY LAST_UPDATED_BY, qilb.LAST_UPDATE_DATE LAST_UPDATE_DATE, qilb.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, qilt.NAME NAME, qilt.DESCRIPTION DESCRIPTION FROM QA_INSPECTION_LEVELS_B qilb, QA_INSPECTION_LEVELS_TL qilt WHERE qilb.INSPECTION_LEVEL_ID = qilt.INSPECTION_LEVEL_ID AND qilt.LANGUAGE = USERENV('LANG')