View: GMD_COM_SPEC_VRS_VL

Product:	GMD - Process Manufacturing Product Development
Description:	View of base columns of all Specification Validity Rules tables
Implementation/DBA Data:	APPS.GMD_COM_SPEC_VRS_VL

View Text

SELECT SPEC_VR_ID
, SPEC_ID
, ORGANIZATION_ID
, 'I' SPEC_TYPE
, PARENT_LOT_NUMBER
, LOT_NUMBER
, SUBINVENTORY
, LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, CONTROL_LOT_ATTRIB_IND
, OUT_OF_SPEC_LOT_STATUS_ID
, IN_SPEC_LOT_STATUS_ID
, NULL CONTROL_BATCH_STEP_IND
, LOT_OPTIONAL_ON_SAMPLE
, DELAYED_LOT_ENTRY
, COA_TYPE
, COA_AT_SHIP_IND
, COA_AT_INVOICE_IND
, COA_REQ_FROM_SUPL_IND
, AUTO_SAMPLE_IND
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, TO_NUMBER (NULL) ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_INVENTORY_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, ORGANIZATION_ID
, 'W' SPEC_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, CONTROL_LOT_ATTRIB_IND
, OUT_OF_SPEC_LOT_STATUS_ID
, IN_SPEC_LOT_STATUS_ID
, CONTROL_BATCH_STEP_IND
, LOT_OPTIONAL_ON_SAMPLE
, DELAYED_LOT_ENTRY
, COA_TYPE
, COA_AT_SHIP_IND
, NULL COA_AT_INVOICE_IND
, COA_REQ_FROM_SUPL_IND
, AUTO_SAMPLE_IND
, BATCH_ID
, RECIPE_ID
, RECIPE_NO
, RECIPE_VERSION
, FORMULA_ID
, FORMULALINE_ID
, FORMULA_NO
, FORMULA_VERS
, ROUTING_ID
, ROUTING_NO
, ROUTING_VERS
, STEP_ID
, STEP_NO
, OPRN_ID
, OPRN_NO
, OPRN_VERS
, CHARGE
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, TO_NUMBER (NULL) ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MATERIAL_DETAIL_ID
FROM GMD_WIP_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, ORGANIZATION_ID
, 'C' SPEC_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, NULL CONTROL_LOT_ATTRIB_IND
, TO_NUMBER (NULL) OUT_OF_SPEC_LOT_STATUS_ID
, TO_NUMBER (NULL) IN_SPEC_LOT_STATUS_ID
, NULL CONTROL_BATCH_STEP_IND
, LOT_OPTIONAL_ON_SAMPLE
, NULL DELAYED_LOT_ENTRY
, COA_TYPE
, COA_AT_SHIP_IND
, COA_AT_INVOICE_IND
, COA_REQ_FROM_SUPL_IND
, NULL AUTO_SAMPLE_IND
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, CUST_ID
, ORDER_ID
, ORDER_LINE
, ORDER_LINE_ID
, SHIP_TO_SITE_ID
, ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_CUSTOMER_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, ORGANIZATION_ID
, 'S' SPEC_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, SAMPLE_INV_TRANS_IND
, CONTROL_LOT_ATTRIB_IND
, OUT_OF_SPEC_LOT_STATUS_ID
, IN_SPEC_LOT_STATUS_ID
, NULL CONTROL_BATCH_STEP_IND
, LOT_OPTIONAL_ON_SAMPLE
, DELAYED_LOT_ENTRY
, COA_TYPE
, NULL COA_AT_SHIP_IND
, NULL COA_AT_INVOICE_IND
, COA_REQ_FROM_SUPL_IND
, AUTO_SAMPLE_IND
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, ORG_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, PO_HEADER_ID
, PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_SUPPLIER_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, DECODE (RULE_TYPE
, 'R'
, RESOURCE_ORGANIZATION_ID
, 'L'
, LOCATOR_ORGANIZATION_ID
, TO_NUMBER (NULL))
, RULE_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, SUBINVENTORY
, LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, NULL SAMPLE_INV_TRANS_IND
, NULL CONTROL_LOT_ATTRIB_IND
, TO_NUMBER (NULL) OUT_OF_SPEC_LOT_STATUS_ID
, TO_NUMBER (NULL) IN_SPEC_LOT_STATUS_ID
, NULL CONTROL_BATCH_STEP_IND
, NULL LOT_OPTIONAL_ON_SAMPLE
, NULL DELAYED_LOT_ENTRY
, NULL COA_TYPE
, NULL COA_AT_SHIP_IND
, NULL COA_AT_INVOICE_IND
, NULL COA_REQ_FROM_SUPL_IND
, NULL AUTO_SAMPLE_IND
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, TO_NUMBER (NULL) ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, RESOURCES
, RESOURCE_INSTANCE_ID
, DELETE_MARK
, TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_MONITORING_SPEC_VRS UNION ALL SELECT SPEC_VR_ID
, SPEC_ID
, TO_NUMBER (NULL) ORGANIZATION_ID
, 'T' SPEC_TYPE
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, SPEC_VR_STATUS
, START_DATE
, END_DATE
, SAMPLING_PLAN_ID
, NULL SAMPLE_INV_TRANS_IND
, NULL CONTROL_LOT_ATTRIB_IND
, TO_NUMBER (NULL) OUT_OF_SPEC_LOT_STATUS_ID
, TO_NUMBER (NULL) IN_SPEC_LOT_STATUS_ID
, NULL CONTROL_BATCH_STEP_IND
, NULL LOT_OPTIONAL_ON_SAMPLE
, NULL DELAYED_LOT_ENTRY
, NULL COA_TYPE
, NULL COA_AT_SHIP_IND
, NULL COA_AT_INVOICE_IND
, NULL COA_REQ_FROM_SUPL_IND
, NULL AUTO_SAMPLE_IND
, TO_NUMBER (NULL) BATCH_ID
, TO_NUMBER (NULL) RECIPE_ID
, NULL RECIPE_NO
, TO_NUMBER (NULL) RECIPE_VERSION
, TO_NUMBER (NULL) FORMULA_ID
, TO_NUMBER (NULL) FORMULALINE_ID
, NULL FORMULA_NO
, TO_NUMBER (NULL) FORMULA_VERS
, TO_NUMBER (NULL) ROUTING_ID
, NULL ROUTING_NO
, TO_NUMBER (NULL) ROUTING_VERS
, TO_NUMBER (NULL) STEP_ID
, TO_NUMBER (NULL) STEP_NO
, TO_NUMBER (NULL) OPRN_ID
, NULL OPRN_NO
, TO_NUMBER (NULL) OPRN_VERS
, TO_NUMBER (NULL) CHARGE
, TO_NUMBER (NULL) CUST_ID
, TO_NUMBER (NULL) ORDER_ID
, TO_NUMBER (NULL) ORDER_LINE
, TO_NUMBER (NULL) ORDER_LINE_ID
, TO_NUMBER (NULL) SHIP_TO_SITE_ID
, TO_NUMBER (NULL) ORG_ID
, TO_NUMBER (NULL) SUPPLIER_ID
, TO_NUMBER (NULL) SUPPLIER_SITE_ID
, TO_NUMBER (NULL) PO_HEADER_ID
, TO_NUMBER (NULL) PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, DELETE_MARK
, TO_NUMBER (NULL) TEXT_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_STABILITY_SPEC_VRS

Columns