VIEW: APPS.MSD_SR_CMRO_FCST_MTLREQ_V

Source

View Text - Preformatted

SELECT msd_sr_util.get_all_org_pk, null, nvl(asm.inventory_item_id, msd_sr_util.get_null_pk), null, msd_sr_util.uom_conv(asm.uom, asm.inventory_item_id) * asm.requested_quantity, asm.requested_date FROM msd_setup_parameters morg, msd_setup_parameters para2, mtl_system_items itm, ahl_schedule_materials asm WHERE morg.parameter_name = 'MSD_MASTER_ORG' and para2.parameter_name = 'MSD_TWO_LEVEL_PLANNING' and itm.inventory_item_id = asm.inventory_item_id and itm.organization_id = morg.parameter_value and asm.material_request_type = 'FORECAST' and decode(nvl(itm.ato_forecast_control,3), 3, decode(nvl(para2.parameter_value, '2'), '1', msd_sr_util.is_product_family_forecastable(morg.parameter_value, asm.inventory_item_id, 2), 2), 1) = 1 and (itm.mrp_planning_code <> 6 or (itm.mrp_planning_code = 6 and itm.pick_components_flag = 'Y'))

View Text - HTML Formatted

SELECT MSD_SR_UTIL.GET_ALL_ORG_PK
, NULL
, NVL(ASM.INVENTORY_ITEM_ID
, MSD_SR_UTIL.GET_NULL_PK)
, NULL
, MSD_SR_UTIL.UOM_CONV(ASM.UOM
, ASM.INVENTORY_ITEM_ID) * ASM.REQUESTED_QUANTITY
, ASM.REQUESTED_DATE
FROM MSD_SETUP_PARAMETERS MORG
, MSD_SETUP_PARAMETERS PARA2
, MTL_SYSTEM_ITEMS ITM
, AHL_SCHEDULE_MATERIALS ASM
WHERE MORG.PARAMETER_NAME = 'MSD_MASTER_ORG'
AND PARA2.PARAMETER_NAME = 'MSD_TWO_LEVEL_PLANNING'
AND ITM.INVENTORY_ITEM_ID = ASM.INVENTORY_ITEM_ID
AND ITM.ORGANIZATION_ID = MORG.PARAMETER_VALUE
AND ASM.MATERIAL_REQUEST_TYPE = 'FORECAST'
AND DECODE(NVL(ITM.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(NVL(PARA2.PARAMETER_VALUE
, '2')
, '1'
, MSD_SR_UTIL.IS_PRODUCT_FAMILY_FORECASTABLE(MORG.PARAMETER_VALUE
, ASM.INVENTORY_ITEM_ID
, 2)
, 2)
, 1) = 1
AND (ITM.MRP_PLANNING_CODE <> 6 OR (ITM.MRP_PLANNING_CODE = 6
AND ITM.PICK_COMPONENTS_FLAG = 'Y'))