Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BOMBV_ECO_REVISED_COMPONENTS |
SELECT CO.EFFECTIVITY_DATE START_EFFECTIVE_DATE
, CO.OPERATION_SEQ_NUM OPERATION_SEQUENCE_NUMBER
, '_KF:INV:MSTK:SY1' "_KF:COMPONENT_ITEM_NAME"
, '_KF:INV:MSTK:SY2' "_KF:BILL_ITEM_NAME"
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, BI.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE
, CO.ITEM_NUM ITEM_SEQUENCE_NUMBER
, CO.COMPONENT_QUANTITY PER_ASSEMBLY_QUANTITY
, CO.COMPONENT_YIELD_FACTOR PROJECTED_YIELD
, CO.COMPONENT_REMARKS COMMENTS
, CO.IMPLEMENTATION_DATE ECO_IMPLEMENTATION_DATE
, CO.PLANNING_FACTOR PLANNING_PERCENT
, CO.LOW_QUANTITY MINIMUM_ALLOWED_QUANTITY
, CO.HIGH_QUANTITY MAXIMUM_ALLOWED_QUANTITY
, CO.DISABLE_DATE END_EFFECTIVE_DATE
, CO.FROM_END_ITEM_UNIT_NUMBER FROM_END_ITEM_UNIT_NUMBER
, CO.TO_END_ITEM_UNIT_NUMBER TO_END_ITEM_UNIT_NUMBER
, CO.SUPPLY_SUBINVENTORY
, CO.OPERATION_LEAD_TIME_PERCENT
, '_LA:CO.INCLUDE_IN_COST_ROLLUP:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.CHECK_ATP:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.INCLUDE_ON_SHIP_DOCS:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.MUTUALLY_EXCLUSIVE_OPTIONS:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.ACD_TYPE:MFG_LOOKUPS:ECG_ACTION:MEANING'
, '_LA:CO.OPTIONAL:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.QUANTITY_RELATED:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.REQUIRED_FOR_REVENUE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.REQUIRED_TO_SHIP:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.SHIPPING_ALLOWED:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.SO_BASIS:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:CO.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, CO.SUPPLY_LOCATOR_ID
, CO.REVISED_ITEM_SEQUENCE_ID
, CO.BILL_SEQUENCE_ID BILL_SEQUENCE_ID
, BI.ORGANIZATION_ID
, CO.COMPONENT_ITEM_ID
, CO.COMPONENT_SEQUENCE_ID COMPONENT_SEQUENCE_ID
, CO.LAST_UPDATE_DATE UPDATED_ON
, CO.LAST_UPDATED_BY UPDATED_BY
, CO.CREATION_DATE CREATED_ON
, CO.CREATED_BY CREATED_BY
FROM MTL_SYSTEM_ITEMS SY1
, MTL_SYSTEM_ITEMS SY2
, HR_ALL_ORGANIZATION_UNITS AL
, BOM_BILL_OF_MATERIALS BI
, MTL_PARAMETERS PA
, BOM_INVENTORY_COMPONENTS CO
WHERE CO.COMPONENT_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND BI.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND BI.ORGANIZATION_ID = SY2.ORGANIZATION_ID
AND BI.ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID
AND CO.BILL_SEQUENCE_ID = BI.BILL_SEQUENCE_ID
AND CO.IMPLEMENTATION_DATE IS NOT NULL
AND '_SEC:BI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY