VIEW: APPS.ENG_REVISED_ITEMS_SCHEDULE_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)