View: MRPFV_PLAN_BILL_OF_MATERIALS

Product:	MRP - Master Scheduling/MRP
Description:
Implementation/DBA Data:	APPS.MRPFV_PLAN_BILL_OF_MATERIALS

View Text

SELECT DISTINCT PARA.ORGANIZATION_CODE
, ORG.NAME
, MRPBOM.COMPILE_DESIGNATOR
, MRPBOM.ALTERNATE_BOM_DESIGNATOR
, '_KF:INV:MSTK:SYSITEM'
, MRPBOM.ORGANIZATION_ID
, MRPBOM.USING_ASSEMBLY_ID
, COMP.BILL_SEQUENCE_ID
FROM HR_ALL_ORGANIZATION_UNITS ORG
, MTL_PARAMETERS PARA
, BOM_INVENTORY_COMPONENTS COMP
, MTL_SYSTEM_ITEMS SYSITEM
, MRP_SYSTEM_ITEMS MRPITEM
, 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 = SYSITEM.ORGANIZATION_ID
AND MRPBOM.USING_ASSEMBLY_ID = SYSITEM.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

Columns