View: GMD_ALL_SPEC_VRS_VL

Product:	GMD - Process Manufacturing Product Development
Description:
Implementation/DBA Data:	APPS.GMD_ALL_SPEC_VRS_VL

View Text

SELECT V.SPEC_VR_ID
, V.SPEC_ID
, V.ORGANIZATION_ID
, PV.ORGANIZATION_CODE
, 'I' SPEC_TYPE
, S.SPEC_NAME
, S.SPEC_VERS
, S.OWNER_ORGANIZATION_ID
, S.OWNER_ID
, S.INVENTORY_ITEM_ID
, I.CONCATENATED_SEGMENTS ITEM_NUMBER
, I.DESCRIPTION
, S.REVISION
, S.GRADE_CODE
, S.SPEC_STATUS
, P.DESCRIPTION SPEC_STATUS_DESC
, V.PARENT_LOT_NUMBER
, V.LOT_NUMBER
, V.SUBINVENTORY
, V.LOCATOR_ID
, L.CONCATENATED_SEGMENTS LOCATOR
, V.SPEC_VR_STATUS
, T.DESCRIPTION SPEC_VR_STATUS_DESC
, V.START_DATE
, V.END_DATE
, V.SAMPLING_PLAN_ID
, V.SAMPLE_INV_TRANS_IND
, V.CONTROL_LOT_ATTRIB_IND
, V.OUT_OF_SPEC_LOT_STATUS_ID
, MS1.STATUS_CODE OUT_OF_SPEC_LOT_STATUS_CODE
, V.IN_SPEC_LOT_STATUS_ID
, MS2.STATUS_CODE IN_SPEC_LOT_STATUS_CODE
, NULL CONTROL_BATCH_STEP_IND
, V.LOT_OPTIONAL_ON_SAMPLE
, V.DELAYED_LOT_ENTRY
, V.COA_TYPE
, V.COA_AT_SHIP_IND
, V.COA_AT_INVOICE_IND
, V.COA_REQ_FROM_SUPL_IND
, V.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
, V.DELETE_MARK
, V.TEXT_CODE
, V.CREATION_DATE
, V.CREATED_BY
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_DATE
, V.LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_INVENTORY_SPEC_VRS V
, GMD_SPECIFICATIONS_B S
, MTL_SYSTEM_ITEMS_KFV I
, MTL_ITEM_LOCATIONS_KFV L
, GMD_QC_STATUS_TL T
, GMD_QC_STATUS_TL P
, MTL_PARAMETERS PV
, MTL_MATERIAL_STATUSES MS1
, MTL_MATERIAL_STATUSES MS2
WHERE V.SPEC_ID = S.SPEC_ID
AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND L.ORGANIZATION_ID(+) = V.ORGANIZATION_ID
AND L.INVENTORY_LOCATION_ID(+) = V.LOCATOR_ID
AND MS1.STATUS_ID(+) = V.OUT_OF_SPEC_LOT_STATUS_ID
AND MS2.STATUS_ID(+) = V.IN_SPEC_LOT_STATUS_ID
AND V.ORGANIZATION_ID = PV.ORGANIZATION_ID(+)
AND V.SPEC_VR_STATUS = T.STATUS_CODE
AND T.ENTITY_TYPE = 'S'
AND T.LANGUAGE = USERENV ('LANG')
AND S.SPEC_STATUS = P.STATUS_CODE
AND P.ENTITY_TYPE = 'S'
AND P.LANGUAGE = USERENV ('LANG') UNION SELECT V.SPEC_VR_ID
, V.SPEC_ID
, V.ORGANIZATION_ID
, PV.ORGANIZATION_CODE
, 'W' SPEC_TYPE
, S.SPEC_NAME
, S.SPEC_VERS
, S.OWNER_ORGANIZATION_ID
, S.OWNER_ID
, S.INVENTORY_ITEM_ID
, I.CONCATENATED_SEGMENTS ITEM_NUMBER
, I.DESCRIPTION
, S.REVISION
, S.GRADE_CODE
, S.SPEC_STATUS
, P.DESCRIPTION SPEC_STATUS_DESC
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, NULL LOCATOR
, V.SPEC_VR_STATUS
, T.DESCRIPTION SPEC_VR_STATUS_DESC
, V.START_DATE
, V.END_DATE
, V.SAMPLING_PLAN_ID
, V.SAMPLE_INV_TRANS_IND
, V.CONTROL_LOT_ATTRIB_IND
, V.OUT_OF_SPEC_LOT_STATUS_ID
, ST2.STATUS_CODE OUT_OF_SPEC_LOT_STATUS_CODE
, V.IN_SPEC_LOT_STATUS_ID
, ST1.STATUS_CODE IN_SPEC_LOT_STATUS_CODE
, V.CONTROL_BATCH_STEP_IND
, V.LOT_OPTIONAL_ON_SAMPLE
, V.DELAYED_LOT_ENTRY
, V.COA_TYPE
, V.COA_AT_SHIP_IND
, NULL COA_AT_INVOICE_IND
, V.COA_REQ_FROM_SUPL_IND
, V.AUTO_SAMPLE_IND
, V.BATCH_ID
, V.RECIPE_ID
, V.RECIPE_NO
, V.RECIPE_VERSION
, V.FORMULA_ID
, V.FORMULALINE_ID
, V.FORMULA_NO
, V.FORMULA_VERS
, V.ROUTING_ID
, V.ROUTING_NO
, V.ROUTING_VERS
, V.STEP_ID
, V.STEP_NO
, V.OPRN_ID
, V.OPRN_NO
, V.OPRN_VERS
, V.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
, V.DELETE_MARK
, V.TEXT_CODE
, V.CREATION_DATE
, V.CREATED_BY
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_DATE
, V.LAST_UPDATE_LOGIN
, V.MATERIAL_DETAIL_ID
FROM GMD_WIP_SPEC_VRS V
, GMD_SPECIFICATIONS_B S
, MTL_SYSTEM_ITEMS_KFV I
, MTL_PARAMETERS PV
, MTL_MATERIAL_STATUSES ST1
, MTL_MATERIAL_STATUSES ST2
, GMD_QC_STATUS_TL T
, GMD_QC_STATUS_TL P
WHERE V.SPEC_ID = S.SPEC_ID
AND I.ORGANIZATION_ID = S.OWNER_ORGANIZATION_ID
AND I.INVENTORY_ITEM_ID = S.INVENTORY_ITEM_ID
AND PV.ORGANIZATION_ID(+) = V.ORGANIZATION_ID
AND V.SPEC_VR_STATUS = T.STATUS_CODE
AND ST1.STATUS_ID(+) = V.IN_SPEC_LOT_STATUS_ID
AND ST2.STATUS_ID(+) = V.OUT_OF_SPEC_LOT_STATUS_ID
AND T.ENTITY_TYPE = 'S'
AND T.LANGUAGE = USERENV ('LANG')
AND S.SPEC_STATUS = P.STATUS_CODE
AND P.ENTITY_TYPE = 'S'
AND P.LANGUAGE = USERENV ('LANG') UNION SELECT V.SPEC_VR_ID
, V.SPEC_ID
, V.ORGANIZATION_ID
, PV.ORGANIZATION_CODE
, 'C' SPEC_TYPE
, S.SPEC_NAME
, S.SPEC_VERS
, S.OWNER_ORGANIZATION_ID
, S.OWNER_ID
, S.INVENTORY_ITEM_ID
, I.CONCATENATED_SEGMENTS ITEM_NUMBER
, I.DESCRIPTION
, S.REVISION
, S.GRADE_CODE
, S.SPEC_STATUS
, P.DESCRIPTION SPEC_STATUS_DESC
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, NULL LOCATOR
, V.SPEC_VR_STATUS
, T.DESCRIPTION SPEC_VR_STATUS_DESC
, V.START_DATE
, V.END_DATE
, V.SAMPLING_PLAN_ID
, V.SAMPLE_INV_TRANS_IND
, NULL CONTROL_LOT_ATTRIB_IND
, TO_NUMBER (NULL) OUT_OF_SPEC_LOT_STATUS_ID
, NULL OUT_OF_SPEC_LOT_STATUS_CODE
, TO_NUMBER (NULL) IN_SPEC_LOT_STATUS_ID
, NULL IN_SPEC_LOT_STATUS_CODE
, NULL CONTROL_BATCH_STEP_IND
, V.LOT_OPTIONAL_ON_SAMPLE
, NULL DELAYED_LOT_ENTRY
, V.COA_TYPE
, V.COA_AT_SHIP_IND
, V.COA_AT_INVOICE_IND
, V.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
, V.DELETE_MARK
, V.TEXT_CODE
, V.CREATION_DATE
, V.CREATED_BY
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_DATE
, V.LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_CUSTOMER_SPEC_VRS V
, GMD_SPECIFICATIONS_B S
, MTL_SYSTEM_ITEMS_KFV I
, MTL_PARAMETERS PV
, GMD_QC_STATUS_TL T
, GMD_QC_STATUS_TL P
WHERE V.SPEC_ID = S.SPEC_ID
AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND PV.ORGANIZATION_ID(+) = V.ORGANIZATION_ID
AND V.SPEC_VR_STATUS = T.STATUS_CODE
AND T.ENTITY_TYPE = 'S'
AND T.LANGUAGE = USERENV ('LANG')
AND S.SPEC_STATUS = P.STATUS_CODE
AND P.ENTITY_TYPE = 'S'
AND P.LANGUAGE = USERENV ('LANG') UNION SELECT V.SPEC_VR_ID
, V.SPEC_ID
, V.ORGANIZATION_ID
, PV.ORGANIZATION_CODE
, 'S' SPEC_TYPE
, S.SPEC_NAME
, S.SPEC_VERS
, S.OWNER_ORGANIZATION_ID
, S.OWNER_ID
, S.INVENTORY_ITEM_ID
, I.CONCATENATED_SEGMENTS ITEM_NUMBER
, I.DESCRIPTION
, S.REVISION
, S.GRADE_CODE
, S.SPEC_STATUS
, P.DESCRIPTION SPEC_STATUS_DESC
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, NULL LOCATOR
, V.SPEC_VR_STATUS
, T.DESCRIPTION SPEC_VR_STATUS_DESC
, V.START_DATE
, V.END_DATE
, V.SAMPLING_PLAN_ID
, V.SAMPLE_INV_TRANS_IND
, V.CONTROL_LOT_ATTRIB_IND
, V.OUT_OF_SPEC_LOT_STATUS_ID
, ST2.STATUS_CODE OUT_OF_SPEC_LOT_STATUS_CODE
, V.IN_SPEC_LOT_STATUS_ID
, ST1.STATUS_CODE IN_SPEC_LOT_STATUS_CODE
, NULL CONTROL_BATCH_STEP_IND
, V.LOT_OPTIONAL_ON_SAMPLE
, V.DELAYED_LOT_ENTRY
, V.COA_TYPE
, NULL COA_AT_SHIP_IND
, NULL COA_AT_INVOICE_IND
, COA_REQ_FROM_SUPL_IND
, V.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
, V.SUPPLIER_ID
, V.SUPPLIER_SITE_ID
, V.PO_HEADER_ID
, V.PO_LINE_ID
, NULL RESOURCES
, TO_NUMBER (NULL) RESOURCE_INSTANCE_ID
, V.DELETE_MARK
, V.TEXT_CODE
, V.CREATION_DATE
, V.CREATED_BY
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_DATE
, V.LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_SUPPLIER_SPEC_VRS V
, GMD_SPECIFICATIONS_B S
, MTL_SYSTEM_ITEMS_KFV I
, MTL_PARAMETERS PV
, GMD_QC_STATUS_TL T
, GMD_QC_STATUS_TL P
, MTL_MATERIAL_STATUSES ST1
, MTL_MATERIAL_STATUSES ST2
WHERE V.SPEC_ID = S.SPEC_ID
AND S.OWNER_ORGANIZATION_ID = I.ORGANIZATION_ID
AND S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
AND PV.ORGANIZATION_ID(+) = V.ORGANIZATION_ID
AND ST1.STATUS_ID(+) = V.IN_SPEC_LOT_STATUS_ID
AND ST2.STATUS_ID(+) = V.OUT_OF_SPEC_LOT_STATUS_ID
AND V.SPEC_VR_STATUS = T.STATUS_CODE
AND T.ENTITY_TYPE = 'S'
AND T.LANGUAGE = USERENV ('LANG')
AND S.SPEC_STATUS = P.STATUS_CODE
AND P.ENTITY_TYPE = 'S'
AND P.LANGUAGE = USERENV ('LANG') UNION SELECT V.SPEC_VR_ID
, V.SPEC_ID
, DECODE (RULE_TYPE
, 'R'
, V.RESOURCE_ORGANIZATION_ID
, 'L'
, V.LOCATOR_ORGANIZATION_ID
, TO_NUMBER (NULL) )
, PV.ORGANIZATION_CODE
, V.RULE_TYPE
, S.SPEC_NAME
, S.SPEC_VERS
, S.OWNER_ORGANIZATION_ID
, S.OWNER_ID
, TO_NUMBER (NULL) INVENTORY_ITEM_ID
, NULL ITEM_NUMBER
, NULL DESCRIPTION
, NULL REVISION
, NULL GRADE_CODE
, S.SPEC_STATUS
, P.DESCRIPTION SPEC_STATUS_DESC
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, V.SUBINVENTORY
, V.LOCATOR_ID
, L.CONCATENATED_SEGMENTS LOCATOR
, V.SPEC_VR_STATUS
, T.DESCRIPTION SPEC_VR_STATUS_DESC
, V.START_DATE
, V.END_DATE
, V.SAMPLING_PLAN_ID
, NULL SAMPLE_INV_TRANS_IND
, NULL CONTROL_LOT_ATTRIB_IND
, NULL OUT_OF_SPEC_LOT_STATUS_ID
, NULL OUT_OF_SPEC_LOT_STATUS_CODE
, NULL IN_SPEC_LOT_STATUS_ID
, NULL IN_SPEC_LOT_STATUS_CODE
, 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
, V.RESOURCES
, V.RESOURCE_INSTANCE_ID
, V.DELETE_MARK
, V.TEXT_CODE
, V.CREATION_DATE
, V.CREATED_BY
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_DATE
, V.LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_MONITORING_SPEC_VRS V
, GMD_SPECIFICATIONS_B S
, MTL_PARAMETERS PV
, MTL_ITEM_LOCATIONS_KFV L
, GMD_QC_STATUS_TL P
, GMD_QC_STATUS_TL T
WHERE V.SPEC_ID = S.SPEC_ID
AND PV.ORGANIZATION_ID(+) = DECODE (RULE_TYPE
, 'R'
, V.RESOURCE_ORGANIZATION_ID
, 'L'
, V.LOCATOR_ORGANIZATION_ID
, NULL )
AND L.ORGANIZATION_ID(+) = DECODE (RULE_TYPE
, 'R'
, V.RESOURCE_ORGANIZATION_ID
, 'L'
, V.LOCATOR_ORGANIZATION_ID
, NULL )
AND L.INVENTORY_LOCATION_ID(+) = V.LOCATOR_ID
AND V.SPEC_VR_STATUS = T.STATUS_CODE
AND T.ENTITY_TYPE = 'S'
AND T.LANGUAGE = USERENV ('LANG')
AND S.SPEC_STATUS = P.STATUS_CODE
AND P.ENTITY_TYPE = 'S'
AND P.LANGUAGE = USERENV ('LANG') UNION SELECT V.SPEC_VR_ID
, V.SPEC_ID
, TO_NUMBER (NULL)
, NULL
, 'T' SPEC_TYPE
, S.SPEC_NAME
, S.SPEC_VERS
, S.OWNER_ORGANIZATION_ID
, S.OWNER_ID
, TO_NUMBER (NULL) INVENTORY_ITEM_ID
, NULL ITEM_NUMBER
, NULL DESCRIPTION
, NULL REVISION
, NULL GRADE_CODE
, S.SPEC_STATUS
, L.DESCRIPTION SPEC_STATUS_DESC
, NULL PARENT_LOT_NUMBER
, NULL LOT_NUMBER
, NULL SUBINVENTORY
, TO_NUMBER (NULL) LOCATOR_ID
, NULL LOCATOR
, V.SPEC_VR_STATUS
, T.DESCRIPTION SPEC_VR_STATUS_DESC
, V.START_DATE
, V.END_DATE
, V.SAMPLING_PLAN_ID
, NULL SAMPLE_INV_TRANS_IND
, NULL CONTROL_LOT_ATTRIB_IND
, TO_NUMBER (NULL) OUT_OF_SPEC_LOT_STATUS_ID
, NULL OUT_OF_SPEC_LOT_STATUS_CODE
, TO_NUMBER (NULL) IN_SPEC_LOT_STATUS_ID
, NULL IN_SPEC_LOT_STATUS_CODE
, 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
, V.DELETE_MARK
, TO_NUMBER (NULL) TEXT_CODE
, V.CREATION_DATE
, V.CREATED_BY
, V.LAST_UPDATED_BY
, V.LAST_UPDATE_DATE
, V.LAST_UPDATE_LOGIN
, TO_NUMBER (NULL) MATERIAL_DETAIL_ID
FROM GMD_STABILITY_SPEC_VRS V
, GMD_SPECIFICATIONS_B S
, GMD_QC_STATUS_TL T
, GMD_QC_STATUS_TL L
WHERE V.SPEC_ID = S.SPEC_ID
AND V.SPEC_VR_STATUS = T.STATUS_CODE
AND S.SPEC_STATUS = L.STATUS_CODE
AND T.ENTITY_TYPE = 'S'
AND L.ENTITY_TYPE = 'S'
AND T.LANGUAGE = USERENV ('LANG')
AND L.LANGUAGE = USERENV ('LANG')

Columns