VIEW: APPS.ENG_WEB_SCHEDULE_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'