View: BOMFV_ECO_REVISED_COMPONENTS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMFV_ECO_REVISED_COMPONENTS

View Text

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

Columns