Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
---|---|
Description: | This view gives Information about Spec Validity Rules defined in OPM QC Module |
Implementation/DBA Data: | APPS.PMITS_QC_ALL_SPEC_VRS_V |
SELECT GASV.SPEC_VR_ID
, GASV.SPEC_ID
, GASV.ORGN_CODE
, GASV.SPEC_TYPE
, QC_SOURCE.MEANING SPEC_TYPE_DISP
, GASV.SPEC_NAME
, GASV.SPEC_VERS
, GASV.ITEM_ID
, GASV.ITEM_NO
, GASV.GRADE
, GASV.SPEC_STATUS
, GASV.SPEC_STATUS_DESC
, GASV.LOT_ID
, GASV.LOT_NO
, GASV.SUBLOT_NO
, GASV.WHSE_CODE
, GASV.LOCATION
, 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
, GASV.IN_SPEC_LOT_STATUS
, 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.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.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.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
, GEM_LOOKUPS FLY
, GEM_LOOKUPS FLN
, GEM_LOOKUPS COA_IND
, GEM_LOOKUPS 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_QC_SOURCE'
AND QC_SOURCE.LOOKUP_CODE = GASV.SPEC_TYPE
AND (GASV.ORGN_CODE IS NULL OR PMI_SECURITY_PKG.SHOW_RECORD(GASV.ORGN_CODE) = 'TRUE')