View: ENG_WEB_SCHEDULE_V

Product:	ENG - Engineering
Description:	Revised items
Implementation/DBA Data:	APPS.ENG_WEB_SCHEDULE_V

View Text

SELECT ERI.REVISED_ITEM_SEQUENCE_ID
, ECO.CHANGE_NOTICE
, MP.ORGANIZATION_CODE
, ECT.CHANGE_ORDER_TYPE
, MLU4.MEANING ECO_STATUS
, EMP.FULL_NAME REQUESTOR
, ORG.NAME DEPARTMENT
, ECO.REASON_CODE
, ECR.DESCRIPTION REASON_DESCRIPTION
, ECO.PRIORITY_CODE
, ECO.INITIATION_DATE
, MLU3.MEANING APPROVAL_STATUS
, ECO.APPROVAL_REQUEST_DATE
, ECO.APPROVAL_DATE
, ERI.REVISED_ITEM_ID
, ERI.ORGANIZATION_ID
, MIF.ITEM_NUMBER REVISED_ITEM
, MIF.PADDED_ITEM_NUMBER PADDED_REVISED_ITEM
, MIF.DESCRIPTION REVISED_ITEM_DESCRIPTION
, BOM.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_DESIGNATOR
, ERI.NEW_ITEM_REVISION
, MLU.MEANING REVISED_ITEM_STATUS
, ERI.SCHEDULED_DATE
, ERI.IMPLEMENTATION_DATE
, MLU6.MEANING MRP_ACTIVE
, MLU5.MEANING UPDATE_WIP
, ERI.BILL_SEQUENCE_ID
, ECO.DESCRIPTION
FROM BOM_BILL_OF_MATERIALS BOM
, MTL_ITEM_FLEXFIELDS MIF
, MFG_LOOKUPS MLU6
, MFG_LOOKUPS MLU5
, MFG_LOOKUPS MLU
, ENG_REVISED_ITEMS ERI
, PER_PEOPLE_F EMP
, HR_ORGANIZATION_UNITS ORG
, ENG_CHANGE_REASONS ECR
, MFG_LOOKUPS MLU3
, MFG_LOOKUPS MLU4
, ENG_CHANGE_ORDER_TYPES ECT
, ENG_ENGINEERING_CHANGES ECO
, MTL_PARAMETERS MP
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 = MIF.ORGANIZATION_ID
AND ERI.REVISED_ITEM_ID = MIF.INVENTORY_ITEM_ID
AND ECO.STATUS_TYPE = MLU4.LOOKUP_CODE
AND MLU4.LOOKUP_TYPE ='ECG_ECN_STATUS'
AND ERI.STATUS_TYPE = MLU.LOOKUP_CODE
AND MLU.LOOKUP_TYPE ='ECG_ECN_STATUS'
AND ECO.APPROVAL_STATUS_TYPE = MLU3.LOOKUP_CODE(+)
AND MLU3.LOOKUP_TYPE(+) = 'ENG_ECN_APPROVAL_STATUS'
AND EMP.PERSON_ID (+) = ECO.REQUESTOR_ID
AND TRUNC(SYSDATE) BETWEEN EMP.EFFECTIVE_START_DATE (+)
AND EMP.EFFECTIVE_END_DATE(+)
AND ECO.RESPONSIBLE_ORGANIZATION_ID = ORG.ORGANIZATION_ID(+)
AND ECR.ENG_CHANGE_REASON_CODE (+) = ECO.REASON_CODE
AND ECR.ORGANIZATION_ID (+) = ECO.ORGANIZATION_ID
AND ECO.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND ERI.UPDATE_WIP = MLU5.LOOKUP_CODE
AND MLU5.LOOKUP_TYPE = 'SYS_YES_NO'
AND ERI.MRP_ACTIVE = MLU6.LOOKUP_CODE
AND MLU6.LOOKUP_TYPE = 'SYS_YES_NO'

Columns