VIEW: APPS.GMD_QC_E_ALL_SPEC_VRS_DISP_V

Source

View Text - Preformatted

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, gasv.delayed_lpn_entry 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

View Text - HTML Formatted

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
, GASV.DELAYED_LPN_ENTRY
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