VIEW: APPS.BOMBV_ECO_REVISED_COMPONENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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