View: MSD_SR_PF_ALL_V

Product:	MSD - Demand Planning
Description:	This is the Source View that associates the Product Family to Top level in the Product Dimension. This view would be applied to an Oracle Applications 11i instance from which the Product Family to Top level association information is to be
Implementation/DBA Data:	APPS.MSD_SR_PF_ALL_V

View Text

SELECT DISTINCT MSIV.INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS
, MSD_SR_UTIL.GET_ALL_PRD_PK
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM MTL_SYSTEM_ITEMS_KFV MSIV
, BOM_BILL_OF_MATERIALS_V BBOMV
WHERE MSIV.BOM_ITEM_TYPE = 5
AND MSIV.ATO_FORECAST_CONTROL <> 3
AND MSIV.MRP_PLANNING_CODE <> 6
AND MSIV.INVENTORY_ITEM_ID = BBOMV.ASSEMBLY_ITEM_ID
AND MSIV.ORGANIZATION_ID = BBOMV.ORGANIZATION_ID UNION SELECT MSD_SR_UTIL.GET_NULL_PK
, MSD_SR_UTIL.GET_NULL_DESC
, MSD_SR_UTIL.GET_ALL_PRD_PK
, MSD_SR_UTIL.GET_ALL_PRD_DESC
, NULL
, NULL
, NULL
, NULL
, NULL
FROM DUAL

Columns