eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BOMFV_ECO_REVISED_COMPONENTS

Source

View Text - Preformatted


SELECT INV.EFFECTIVITY_DATE START_EFFECTIVE_DATE , INV.OPERATION_SEQ_NUM OPERATION_SEQUENCE_NUMBER , AL.NAME ORGANIZATION_NAME , PA.ORGANIZATION_CODE , BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE , '_KF:INV:MSTK:SY2' "_KF:COMPONENT_ITEM_NAME" , '_KF:INV:MSTK:SY1' "_KF:BILL_ITEM_NAME" , INV.ITEM_NUM ITEM_SEQUENCE_NUMBER , INV.COMPONENT_QUANTITY QUANTITY_PER_ASSEMBLY , INV.COMPONENT_YIELD_FACTOR PROJECTED_YIELD , INV.COMPONENT_REMARKS "COMMENTS" , INV.CHANGE_NOTICE , INV.IMPLEMENTATION_DATE , INV.DISABLE_DATE END_EFFECTIVE_DATE , INV.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER , INV.TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER , INV.PLANNING_FACTOR , INV.LOW_QUANTITY MINIMUM_ALLOWED_QUANTITY , INV.HIGH_QUANTITY MAXIMUM_ALLOWED_QUANTITY , INV.OPERATION_LEAD_TIME_PERCENT OPERATION_OFFSET_IN_ROUTING , INV.SUPPLY_SUBINVENTORY , '_LA:INV.BOM_ITEM_TYPE:MFG_LOOKUPS:BOM_ITEM_TYPE:MEANING' , '_LA:INV.INCLUDE_IN_COST_ROLLUP:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:INV.CHECK_ATP:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:INV.INCLUDE_ON_SHIP_DOCS:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:INV.MUTUALLY_EXCLUSIVE_OPTIONS:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:INV.OPTIONAL:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:INV.QUANTITY_RELATED:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:INV.REQUIRED_FOR_REVENUE:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:INV.REQUIRED_TO_SHIP:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:INV.SHIPPING_ALLOWED:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:INV.SO_BASIS:MFG_LOOKUPS:BOM_SO_BASIS:MEANING' , '_LA:INV.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING' , '_LA:INV.ACD_TYPE:MFG_LOOKUPS:ECG_ACTION:MEANING' , '_KF:INV:MSTK:SY3' "_KF:REVISED_ITEM_NAME" , '_KF:INV:MTLL:LO' "_KF:SUPPLY LOCATOR NAME" , '_DF:BOM:BOM_INVENTORY_COMPONENTS:INV' , INV.COMPONENT_SEQUENCE_ID , INV.COMPONENT_ITEM_ID , INV.OLD_COMPONENT_SEQUENCE_ID , INV.BILL_SEQUENCE_ID , INV.SUPPLY_LOCATOR_ID , INV.REVISED_ITEM_SEQUENCE_ID , BI.ASSEMBLY_ITEM_ID , BI.ORGANIZATION_ID, INV.CREATION_DATE CREATED_ON , INV.CREATED_BY , INV.LAST_UPDATE_DATE UPDATED_ON , INV.LAST_UPDATED_BY UPDATED_BY FROM ENG_REVISED_ITEMS REV , MTL_ITEM_LOCATIONS LO , MTL_SYSTEM_ITEMS_B SY3 , HR_ALL_ORGANIZATION_UNITS AL , MTL_PARAMETERS PA , MTL_SYSTEM_ITEMS_B SY2 , BOM_BILL_OF_MATERIALS BI , MTL_SYSTEM_ITEMS_B SY1 , BOM_INVENTORY_COMPONENTS INV WHERE INV.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID AND BI.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID AND BI.ORGANIZATION_ID = SY1.ORGANIZATION_ID AND INV.COMPONENT_ITEM_ID = SY2.INVENTORY_ITEM_ID AND BI.ORGANIZATION_ID = SY2.ORGANIZATION_ID AND INV.REVISED_ITEM_SEQUENCE_ID = REV.REVISED_ITEM_SEQUENCE_ID(+) AND REV.REVISED_ITEM_ID =SY3.INVENTORY_ITEM_ID(+) AND REV.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+) AND INV.SUPPLY_LOCATOR_ID = LO.INVENTORY_LOCATION_ID(+) AND DECODE(INV.SUPPLY_LOCATOR_ID, NULL, -1, BI.ORGANIZATION_ID) = DECODE(INV.SUPPLY_LOCATOR_ID, NULL, -1 ,LO.ORGANIZATION_ID) AND INV.IMPLEMENTATION_DATE IS NULL AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT INV.EFFECTIVITY_DATE START_EFFECTIVE_DATE
, INV.OPERATION_SEQ_NUM OPERATION_SEQUENCE_NUMBER
, AL.NAME ORGANIZATION_NAME
, PA.ORGANIZATION_CODE
, BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE
, '_KF:INV:MSTK:SY2' "_KF:COMPONENT_ITEM_NAME"
, '_KF:INV:MSTK:SY1' "_KF:BILL_ITEM_NAME"
, INV.ITEM_NUM ITEM_SEQUENCE_NUMBER
, INV.COMPONENT_QUANTITY QUANTITY_PER_ASSEMBLY
, INV.COMPONENT_YIELD_FACTOR PROJECTED_YIELD
, INV.COMPONENT_REMARKS "COMMENTS"
, INV.CHANGE_NOTICE
, INV.IMPLEMENTATION_DATE
, INV.DISABLE_DATE END_EFFECTIVE_DATE
, INV.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, INV.TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
, INV.PLANNING_FACTOR
, INV.LOW_QUANTITY MINIMUM_ALLOWED_QUANTITY
, INV.HIGH_QUANTITY MAXIMUM_ALLOWED_QUANTITY
, INV.OPERATION_LEAD_TIME_PERCENT OPERATION_OFFSET_IN_ROUTING
, INV.SUPPLY_SUBINVENTORY
, '_LA:INV.BOM_ITEM_TYPE:MFG_LOOKUPS:BOM_ITEM_TYPE:MEANING'
, '_LA:INV.INCLUDE_IN_COST_ROLLUP:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:INV.CHECK_ATP:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:INV.INCLUDE_ON_SHIP_DOCS:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:INV.MUTUALLY_EXCLUSIVE_OPTIONS:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:INV.OPTIONAL:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:INV.QUANTITY_RELATED:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:INV.REQUIRED_FOR_REVENUE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:INV.REQUIRED_TO_SHIP:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:INV.SHIPPING_ALLOWED:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:INV.SO_BASIS:MFG_LOOKUPS:BOM_SO_BASIS:MEANING'
, '_LA:INV.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, '_LA:INV.ACD_TYPE:MFG_LOOKUPS:ECG_ACTION:MEANING'
, '_KF:INV:MSTK:SY3' "_KF:REVISED_ITEM_NAME"
, '_KF:INV:MTLL:LO' "_KF:SUPPLY LOCATOR NAME"
, '_DF:BOM:BOM_INVENTORY_COMPONENTS:INV'
, INV.COMPONENT_SEQUENCE_ID
, INV.COMPONENT_ITEM_ID
, INV.OLD_COMPONENT_SEQUENCE_ID
, INV.BILL_SEQUENCE_ID
, INV.SUPPLY_LOCATOR_ID
, INV.REVISED_ITEM_SEQUENCE_ID
, BI.ASSEMBLY_ITEM_ID
, BI.ORGANIZATION_ID
, INV.CREATION_DATE CREATED_ON
, INV.CREATED_BY
, INV.LAST_UPDATE_DATE UPDATED_ON
, INV.LAST_UPDATED_BY UPDATED_BY
FROM ENG_REVISED_ITEMS REV
, MTL_ITEM_LOCATIONS LO
, MTL_SYSTEM_ITEMS_B SY3
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_SYSTEM_ITEMS_B SY2
, BOM_BILL_OF_MATERIALS BI
, MTL_SYSTEM_ITEMS_B SY1
, BOM_INVENTORY_COMPONENTS INV
WHERE INV.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID
AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND BI.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND INV.COMPONENT_ITEM_ID = SY2.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY2.ORGANIZATION_ID
AND INV.REVISED_ITEM_SEQUENCE_ID = REV.REVISED_ITEM_SEQUENCE_ID(+)
AND REV.REVISED_ITEM_ID =SY3.INVENTORY_ITEM_ID(+)
AND REV.ORGANIZATION_ID = SY3.ORGANIZATION_ID(+)
AND INV.SUPPLY_LOCATOR_ID = LO.INVENTORY_LOCATION_ID(+)
AND DECODE(INV.SUPPLY_LOCATOR_ID
, NULL
, -1
, BI.ORGANIZATION_ID) = DECODE(INV.SUPPLY_LOCATOR_ID
, NULL
, -1
, LO.ORGANIZATION_ID)
AND INV.IMPLEMENTATION_DATE IS NULL
AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY