View: ENG_REVISED_ITEMS_SCHEDULE_V

Product:	ENG - Engineering
Description:	Engineering change order schedules
Implementation/DBA Data:	APPS.ENG_REVISED_ITEMS_SCHEDULE_V

View Text

SELECT /* ORDERED FIRST_ROWS*/ ECO.CHANGE_NOTICE
, ECO.ORGANIZATION_ID
, ERI.ROWID ROW_ID
, ECO.RESPONSIBLE_ORGANIZATION_ID
, ERI.NEW_ITEM_REVISION
, ERI.STATUS_TYPE REVISED_ITEM_STATUS_TYPE
, MLU.MEANING REVISED_ITEM_STATUS
, ERI.SCHEDULED_DATE
, ERI.REVISED_ITEM_ID
, MSIB.CONCATENATED_SEGMENTS REVISED_ITEM
, MSIT.DESCRIPTION REVISED_ITEM_DESCRIPTION
, FCL.MEANING ITEM_TYPE
, BOM.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ERI.MRP_ACTIVE
, ERI.UPDATE_WIP
, ERI.USE_UP
, ERI.USE_UP_ITEM_ID
, ERI.USE_UP_PLAN_NAME
, ERI.DISPOSITION_TYPE
, MLU2.MEANING DISPOSITION
, ECT.TYPE_NAME CHANGE_ORDER_TYPE
, ECT.CHANGE_ORDER_TYPE_ID
, ECO.REASON_CODE
, ECO.PRIORITY_CODE
, ECO.INITIATION_DATE
, ECO.APPROVAL_STATUS_TYPE
, MLU3.MEANING APPROVAL_STATUS
, ECO.APPROVAL_REQUEST_DATE
, ECO.APPROVAL_DATE
, ERI.IMPLEMENTATION_DATE
, ERI.LAST_UPDATE_DATE
, ERI.LAST_UPDATED_BY
, ERI.CREATION_DATE
, ERI.CREATED_BY
, ERI.LAST_UPDATE_LOGIN
, /* ERI.DESCRIPTIVE_TEXT
, */ ECO.DESCRIPTION DESCRIPTIVE_TEXT
, ERI.CANCELLATION_DATE
, ERI.CANCEL_COMMENTS
, ERI.AUTO_IMPLEMENT_DATE
, DECODE(ERI.AUTO_IMPLEMENT_DATE
, NULL
, 2
, 1) AUTO_IMPLEMENTED_FLAG
, ERI.EARLY_SCHEDULE_DATE
, ERI.BILL_SEQUENCE_ID
, ERI.REVISED_ITEM_SEQUENCE_ID
, ECO.STATUS_TYPE ECO_STATUS_TYPE
, MLU4.MEANING ECO_STATUS
, ERI.REQUEST_ID
, ERI.PROGRAM_APPLICATION_ID
, ERI.PROGRAM_ID
, ERI.PROGRAM_UPDATE_DATE
, HOU.NAME DEPARTMENT_NAME
FROM MFG_LOOKUPS MLU2
, MFG_LOOKUPS MLU
, MFG_LOOKUPS MLU4
, MFG_LOOKUPS MLU3
, FND_COMMON_LOOKUPS FCL
, MTL_SYSTEM_ITEMS_B_KFV MSIB
, MTL_SYSTEM_ITEMS_TL MSIT
, ENG_CHANGE_ORDER_TYPES_VL ECT
, BOM_BILL_OF_MATERIALS BOM
, ENG_REVISED_ITEMS ERI
, ENG_ENGINEERING_CHANGES ECO
, HR_ORGANIZATION_UNITS HOU
WHERE ECO.CHANGE_NOTICE = ERI.CHANGE_NOTICE
AND ECO.ORGANIZATION_ID = ERI.ORGANIZATION_ID
AND ERI.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID(+)
AND ECO.CHANGE_ORDER_TYPE_ID = ECT.CHANGE_ORDER_TYPE_ID
AND ERI.ORGANIZATION_ID = MSIB.ORGANIZATION_ID
AND ERI.REVISED_ITEM_ID = MSIB.INVENTORY_ITEM_ID
AND MSIB.ORGANIZATION_ID = MSIT.ORGANIZATION_ID
AND MSIB.INVENTORY_ITEM_ID = MSIT.INVENTORY_ITEM_ID
AND MSIT.LANGUAGE = USERENV('LANG')
AND MLU4.LOOKUP_TYPE ='ECG_ECN_STATUS'
AND ECO.STATUS_TYPE = MLU4.LOOKUP_CODE
AND ERI.STATUS_TYPE = MLU.LOOKUP_CODE
AND MLU.LOOKUP_TYPE ='ECG_ECN_STATUS'
AND ERI.DISPOSITION_TYPE = MLU2.LOOKUP_CODE(+)
AND MLU2.LOOKUP_TYPE(+) = 'ECG_MATERIAL_DISPOSITION'
AND ECO.APPROVAL_STATUS_TYPE = MLU3.LOOKUP_CODE(+)
AND MLU3.LOOKUP_TYPE(+) = 'ENG_ECN_APPROVAL_STATUS'
AND MSIB.ITEM_TYPE = FCL.LOOKUP_CODE(+)
AND FCL.LOOKUP_TYPE(+) = 'ITEM_TYPE'
AND FCL.APPLICATION_ID(+) = 401
AND ECO.RESPONSIBLE_ORGANIZATION_ID = HOU.ORGANIZATION_ID(+)

Columns