VIEW: APPS.MRPFV_PLAN_BOM_COMPONENTS

Source

View Text - Preformatted

SELECT DISTINCT PARA.ORGANIZATION_CODE ,ORG.NAME ,MRPBOM.COMPILE_DESIGNATOR ,MRPBOM.ALTERNATE_BOM_DESIGNATOR ,'_KF:INV:MSTK:SYSITEM' ,'_KF:INV:MSTK:SYSCOMP' ,MRPBOM.OPERATION_SEQ_NUM ,MRPBOM.EFFECTIVITY_DATE ,MRPBOM.USAGE_QUANTITY ,MRPBOM.OPERATION_OFFSET_PERCENT ,MRPBOM.CHANGE_NOTICE ,MRPBOM.USE_UP_CODE ,MRPBOM.DISABLE_DATE ,'_LA:MRPBOM.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING' ,'_LA:MRPBOM.OPTIONAL_COMPONENT:MFG_LOOKUPS:SYS_YES_NO:MEANING' ,MRPBOM.FROM_END_ITEM_UNIT_NUMBER ,MRPBOM.TO_END_ITEM_UNIT_NUMBER ,MRPBOM.ORGANIZATION_ID ,MRPBOM.INVENTORY_ITEM_ID ,MRPBOM.USING_ASSEMBLY_ID ,COMP.COMPONENT_SEQUENCE_ID ,MRPBOM.LAST_UPDATE_DATE ,MRPBOM.LAST_UPDATED_BY ,MRPBOM.CREATION_DATE ,MRPBOM.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS org, MTL_PARAMETERS para, BOM_INVENTORY_COMPONENTS comp, MTL_SYSTEM_ITEMS sysitem, MTL_SYSTEM_ITEMS syscomp, MRP_SYSTEM_ITEMS mrpitem, MRP_SYSTEM_ITEMS mrpcomp, MRP_BOM_COMPONENTS mrpbom WHERE mrpbom.ORGANIZATION_ID = mrpitem.ORGANIZATION_ID and mrpbom.COMPILE_DESIGNATOR = mrpitem.COMPILE_DESIGNATOR and mrpbom.USING_ASSEMBLY_ID = mrpitem.INVENTORY_ITEM_ID and mrpbom.ORGANIZATION_ID = mrpcomp.ORGANIZATION_ID and mrpbom.COMPILE_DESIGNATOR = mrpcomp.COMPILE_DESIGNATOR and mrpbom.INVENTORY_ITEM_ID = mrpcomp.INVENTORY_ITEM_ID and mrpbom.ORGANIZATION_ID = sysitem.ORGANIZATION_ID and mrpbom.USING_ASSEMBLY_ID = sysitem.INVENTORY_ITEM_ID and mrpbom.ORGANIZATION_ID = syscomp.ORGANIZATION_ID and mrpbom.INVENTORY_ITEM_ID = syscomp.INVENTORY_ITEM_ID and mrpbom.COMPONENT_SEQUENCE_ID = comp.COMPONENT_SEQUENCE_ID and mrpbom.ORGANIZATION_ID = para.ORGANIZATION_ID and mrpbom.ORGANIZATION_ID = org.ORGANIZATION_ID and '_SEC:MRPBOM.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT DISTINCT PARA.ORGANIZATION_CODE
, ORG.NAME
, MRPBOM.COMPILE_DESIGNATOR
, MRPBOM.ALTERNATE_BOM_DESIGNATOR
, '_KF:INV:MSTK:SYSITEM'
, '_KF:INV:MSTK:SYSCOMP'
, MRPBOM.OPERATION_SEQ_NUM
, MRPBOM.EFFECTIVITY_DATE
, MRPBOM.USAGE_QUANTITY
, MRPBOM.OPERATION_OFFSET_PERCENT
, MRPBOM.CHANGE_NOTICE
, MRPBOM.USE_UP_CODE
, MRPBOM.DISABLE_DATE
, '_LA:MRPBOM.WIP_SUPPLY_TYPE:MFG_LOOKUPS:WIP_SUPPLY:MEANING'
, '_LA:MRPBOM.OPTIONAL_COMPONENT:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, MRPBOM.FROM_END_ITEM_UNIT_NUMBER
, MRPBOM.TO_END_ITEM_UNIT_NUMBER
, MRPBOM.ORGANIZATION_ID
, MRPBOM.INVENTORY_ITEM_ID
, MRPBOM.USING_ASSEMBLY_ID
, COMP.COMPONENT_SEQUENCE_ID
, MRPBOM.LAST_UPDATE_DATE
, MRPBOM.LAST_UPDATED_BY
, MRPBOM.CREATION_DATE
, MRPBOM.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS ORG
, MTL_PARAMETERS PARA
, BOM_INVENTORY_COMPONENTS COMP
, MTL_SYSTEM_ITEMS SYSITEM
, MTL_SYSTEM_ITEMS SYSCOMP
, MRP_SYSTEM_ITEMS MRPITEM
, MRP_SYSTEM_ITEMS MRPCOMP
, MRP_BOM_COMPONENTS MRPBOM
WHERE MRPBOM.ORGANIZATION_ID = MRPITEM.ORGANIZATION_ID
AND MRPBOM.COMPILE_DESIGNATOR = MRPITEM.COMPILE_DESIGNATOR
AND MRPBOM.USING_ASSEMBLY_ID = MRPITEM.INVENTORY_ITEM_ID
AND MRPBOM.ORGANIZATION_ID = MRPCOMP.ORGANIZATION_ID
AND MRPBOM.COMPILE_DESIGNATOR = MRPCOMP.COMPILE_DESIGNATOR
AND MRPBOM.INVENTORY_ITEM_ID = MRPCOMP.INVENTORY_ITEM_ID
AND MRPBOM.ORGANIZATION_ID = SYSITEM.ORGANIZATION_ID
AND MRPBOM.USING_ASSEMBLY_ID = SYSITEM.INVENTORY_ITEM_ID
AND MRPBOM.ORGANIZATION_ID = SYSCOMP.ORGANIZATION_ID
AND MRPBOM.INVENTORY_ITEM_ID = SYSCOMP.INVENTORY_ITEM_ID
AND MRPBOM.COMPONENT_SEQUENCE_ID = COMP.COMPONENT_SEQUENCE_ID
AND MRPBOM.ORGANIZATION_ID = PARA.ORGANIZATION_ID
AND MRPBOM.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND '_SEC:MRPBOM.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY