[Home] [Help]
View: ENG_CHANGE_ORDER_TYPES_VAL_V
View Text
SELECT ECT.TYPE_NAME CHANGE_ORDER_TYPE
, ECT.DESCRIPTION
, ECT.CHANGE_ORDER_TYPE_ID
, ECT.ASSEMBLY_TYPE
, ECT.CHANGE_ORDER_ORGANIZATION_ID
, ML.MEANING BILL_TYPE
, ECT.CHANGE_MGMT_TYPE_CODE
, ECT.TYPE_CLASSIFICATION
FROM ENG_CHANGE_ORDER_TYPES_V ECT
, MFG_LOOKUPS ML
WHERE ML.LOOKUP_CODE = ECT.ASSEMBLY_TYPE
AND ML.LOOKUP_TYPE = 'ECG_BOM_COMP_SEL'
AND NVL(ECT.DISABLE_DATE
, SYSDATE + 1) > SYSDATE
Columns
Name |
CHANGE_ORDER_TYPE |
DESCRIPTION |
CHANGE_ORDER_TYPE_ID |
ASSEMBLY_TYPE |
CHANGE_ORDER_ORGANIZATION_ID |
BILL_TYPE |
CHANGE_MGMT_TYPE_CODE |
TYPE_CLASSIFICATION |