VIEW: APPS.ENGFV_ECO_REVISED_ITEMS

Source

View Text - Preformatted

SELECT '_KF:INV:MSTK:SY1' "_KF:REVISED_ITEM_NAME" , RE.NEW_ITEM_REVISION , RE.SCHEDULED_DATE START_EFFECTIVE_DATE , RE.IMPLEMENTATION_DATE , RE.DESCRIPTIVE_TEXT CHANGE_DESCRIPTION , RE.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER , RE.CANCELLATION_DATE , RE.CANCEL_COMMENTS CANCELLATION_COMMENTS , RE.EARLY_SCHEDULE_DATE EARLIEST_EFFECTIVE_DATE , RE.USE_UP_PLAN_NAME , '_LA:RE.STATUS_TYPE:MFG_LOOKUPS:ECG_ECN_STATUS:MEANING' , '_LA:RE.DISPOSITION_TYPE:MFG_LOOKUPS:ECG_MATERIAL_DISPOSITION:MEANING' , '_LA:RE.MRP_ACTIVE:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:RE.UPDATE_WIP:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:RE.USE_UP:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_KF:INV:MTLL:SY2' "_KF:USE_UP_ITEM_NAME" , RE.CHANGE_NOTICE ECO_NAME , PA.ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , BI.ALTERNATE_BOM_DESIGNATOR BOM_ALTERNATE_CODE , '_DF:ENG:ENG_REVISED_ITEMS:RE' , RE.ORGANIZATION_ID , RE.REVISED_ITEM_ID , RE.REVISED_ITEM_SEQUENCE_ID , RE.BILL_SEQUENCE_ID , RE.USE_UP_ITEM_ID , RE.CREATION_DATE CREATED_ON , RE.CREATED_BY , RE.LAST_UPDATE_DATE UPDATED_ON, RE.LAST_UPDATED_BY UPDATED_BY FROM MTL_SYSTEM_ITEMS_B SY2,BOM_STRUCTURES_B BI,MTL_SYSTEM_ITEMS_B SY1,MTL_PARAMETERS PA,HR_ALL_ORGANIZATION_UNITS AL,ENG_REVISED_ITEMS RE WHERE RE.ORGANIZATION_ID = AL.ORGANIZATION_ID AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID AND RE.REVISED_ITEM_ID = SY1.INVENTORY_ITEM_ID AND RE.ORGANIZATION_ID = SY1.ORGANIZATION_ID AND RE.USE_UP_ITEM_ID = SY2.INVENTORY_ITEM_ID(+) AND RE.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+) AND RE.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID(+) AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT '_KF:INV:MSTK:SY1' "_KF:REVISED_ITEM_NAME"
, RE.NEW_ITEM_REVISION
, RE.SCHEDULED_DATE START_EFFECTIVE_DATE
, RE.IMPLEMENTATION_DATE
, RE.DESCRIPTIVE_TEXT CHANGE_DESCRIPTION
, RE.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, RE.CANCELLATION_DATE
, RE.CANCEL_COMMENTS CANCELLATION_COMMENTS
, RE.EARLY_SCHEDULE_DATE EARLIEST_EFFECTIVE_DATE
, RE.USE_UP_PLAN_NAME
, '_LA:RE.STATUS_TYPE:MFG_LOOKUPS:ECG_ECN_STATUS:MEANING'
, '_LA:RE.DISPOSITION_TYPE:MFG_LOOKUPS:ECG_MATERIAL_DISPOSITION:MEANING'
, '_LA:RE.MRP_ACTIVE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:RE.UPDATE_WIP:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:RE.USE_UP:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_KF:INV:MTLL:SY2' "_KF:USE_UP_ITEM_NAME"
, RE.CHANGE_NOTICE ECO_NAME
, PA.ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, BI.ALTERNATE_BOM_DESIGNATOR BOM_ALTERNATE_CODE
, '_DF:ENG:ENG_REVISED_ITEMS:RE'
, RE.ORGANIZATION_ID
, RE.REVISED_ITEM_ID
, RE.REVISED_ITEM_SEQUENCE_ID
, RE.BILL_SEQUENCE_ID
, RE.USE_UP_ITEM_ID
, RE.CREATION_DATE CREATED_ON
, RE.CREATED_BY
, RE.LAST_UPDATE_DATE UPDATED_ON
, RE.LAST_UPDATED_BY UPDATED_BY
FROM MTL_SYSTEM_ITEMS_B SY2
, BOM_STRUCTURES_B BI
, MTL_SYSTEM_ITEMS_B SY1
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, ENG_REVISED_ITEMS RE
WHERE RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.REVISED_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND RE.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND RE.USE_UP_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND RE.ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND RE.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID(+)
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY