View: GMD_QC_E_ALL_SPEC_VRS_DISP_V

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

View Text

SELECT GASV.SPEC_VR_ID
, GASV.SPEC_ID
, GASV.ORGANIZATION_CODE
, GASV.SPEC_TYPE
, QC_SOURCE.MEANING SPEC_TYPE_DISP
, GASV.SPEC_NAME
, GASV.SPEC_VERS
, GASV.INVENTORY_ITEM_ID
, GASV.REVISION
, GASV.DESCRIPTION
, GASV.GRADE_CODE
, GASV.SPEC_STATUS
, GASV.SPEC_STATUS_DESC
, GASV.PARENT_LOT_NUMBER
, GASV.LOT_NUMBER
, GASV.SUBINVENTORY
, GASV.LOCATOR
, GASV.SPEC_VR_STATUS
, GASV.SPEC_VR_STATUS_DESC
, GASV.START_DATE
, GASV.END_DATE
, GASV.SAMPLING_PLAN_ID
, GASV.SAMPLE_INV_TRANS_IND
, DECODE (GASV.SAMPLE_INV_TRANS_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING) SAMPLE_INV_TRANS_IND_DISP
, GASV.CONTROL_LOT_ATTRIB_IND
, DECODE (GASV.CONTROL_LOT_ATTRIB_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING) CONTROL_LOT_ATTRIB_IND_DISP
, GASV.OUT_OF_SPEC_LOT_STATUS_ID
, GASV.OUT_OF_SPEC_LOT_STATUS_CODE
, GASV.IN_SPEC_LOT_STATUS_ID
, GASV.IN_SPEC_LOT_STATUS_CODE
, GASV.CONTROL_BATCH_STEP_IND
, DECODE (GASV.CONTROL_BATCH_STEP_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING) CONTROL_BATCH_STEP_IND_DISP
, GASV.LOT_OPTIONAL_ON_SAMPLE
, GASV.DELAYED_LOT_ENTRY
, GASV.COA_TYPE
, COA_IND.MEANING COA_TYPE_DISP
, GASV.COA_AT_SHIP_IND
, DECODE (GASV.COA_AT_SHIP_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING) COA_AT_SHIP_IND_DISP
, GASV.COA_AT_INVOICE_IND
, DECODE (GASV.COA_AT_INVOICE_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING) COA_AT_INVOICE_IND_DISP
, COA_REQ_FROM_SUPL_IND
, DECODE (GASV.COA_REQ_FROM_SUPL_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING) COA_REQ_FROM_SUPL_IND_DISP
, GASV.AUTO_SAMPLE_IND
, DECODE (GASV.AUTO_SAMPLE_IND
, 'Y'
, FLY.MEANING
, FLN.MEANING) AUTO_SAMPLE_IND_DISP
, GASV.BATCH_ID
, GASV.RECIPE_ID
, GASV.RECIPE_NO
, GASV.RECIPE_VERSION
, GASV.FORMULA_ID
, GASV.FORMULALINE_ID
, GASV.FORMULA_NO
, GASV.FORMULA_VERS
, GASV.ROUTING_ID
, GASV.ROUTING_NO
, GASV.ROUTING_VERS
, GASV.STEP_ID
, GASV.STEP_NO
, GASV.OPRN_ID
, GASV.OPRN_NO
, GASV.OPRN_VERS
, GASV.CHARGE
, GASV.CUST_ID
, GASV.ORDER_ID
, GASV.ORDER_LINE
, GASV.ORDER_LINE_ID
, GASV.SHIP_TO_SITE_ID
, GASV.ORG_ID
, GASV.SUPPLIER_ID
, GASV.SUPPLIER_SITE_ID
, GASV.PO_HEADER_ID
, GASV.PO_LINE_ID
, GASV.RESOURCES
, GASV.RESOURCE_INSTANCE_ID
, GASV.DELETE_MARK
, GASV.TEXT_CODE
, GASV.CREATION_DATE
, GASV.CREATED_BY
, GASV.LAST_UPDATED_BY
, GASV.LAST_UPDATE_DATE
, GASV.LAST_UPDATE_LOGIN
FROM GMD_ALL_SPEC_VRS GASV
, FND_LOOKUP_VALUES_VL FLY
, FND_LOOKUP_VALUES_VL FLN
, FND_LOOKUP_VALUES_VL COA_IND
, FND_LOOKUP_VALUES_VL QC_SOURCE
WHERE FLY.LOOKUP_TYPE = 'GMD_QC_YES_NO'
AND FLY.LOOKUP_CODE = 'Y'
AND FLN.LOOKUP_TYPE = 'GMD_QC_YES_NO'
AND FLN.LOOKUP_CODE = 'N'
AND COA_IND.LOOKUP_TYPE(+) = 'GMD_QM_CERTIFICATION_TYPE'
AND GASV.COA_TYPE = COA_IND.LOOKUP_CODE(+)
AND QC_SOURCE.LOOKUP_TYPE = 'GMD_ERES_SOURCE'
AND QC_SOURCE.LOOKUP_CODE = GASV.SPEC_TYPE

Columns