VIEW: APPS.MSD_SR_ACTUAL_PRODUCTION_V

Source

View Text - Preformatted

SELECT prod.organization_id, null, prod.inventory_item_id, null, msd_sr_util.get_all_geo_pk, null, msd_sr_util.get_null_pk, null, msd_sr_util.get_null_pk, null, msd_sr_util.get_all_dcs_pk, null, odj.completion_date, msd_sr_util.uom_conv(prod.uom_code, prod.inventory_item_id) * prod.completion_quantity, msd_sr_util.get_null_pk, null, msd_sr_util.get_null_pk, null FROM OPI_DBI_WIP_COMP_F prod, OPI_DBI_JOBS_F ODJ, MTL_SYSTEM_ITEMS itm, msd_app_instance_orgs app, msd_setup_parameters morg, msd_setup_parameters para2 WHERE morg.parameter_name = 'MSD_MASTER_ORG' and para2.parameter_name = 'MSD_TWO_LEVEL_PLANNING' AND prod.inventory_item_id = itm.inventory_item_id AND prod.organization_id = itm.organization_id and app.organization_id = prod.organization_id 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, prod.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')) and prod.organization_id=odj.organization_id and prod.job_id= odj.job_id and prod.job_type=odj.job_type and prod.inventory_item_id=odj.assembly_item_id and prod.line_type =odj.line_type

View Text - HTML Formatted

SELECT PROD.ORGANIZATION_ID
, NULL
, PROD.INVENTORY_ITEM_ID
, NULL
, MSD_SR_UTIL.GET_ALL_GEO_PK
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, NULL
, MSD_SR_UTIL.GET_ALL_DCS_PK
, NULL
, ODJ.COMPLETION_DATE
, MSD_SR_UTIL.UOM_CONV(PROD.UOM_CODE
, PROD.INVENTORY_ITEM_ID) * PROD.COMPLETION_QUANTITY
, MSD_SR_UTIL.GET_NULL_PK
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, NULL
FROM OPI_DBI_WIP_COMP_F PROD
, OPI_DBI_JOBS_F ODJ
, MTL_SYSTEM_ITEMS ITM
, MSD_APP_INSTANCE_ORGS APP
, MSD_SETUP_PARAMETERS MORG
, MSD_SETUP_PARAMETERS PARA2
WHERE MORG.PARAMETER_NAME = 'MSD_MASTER_ORG'
AND PARA2.PARAMETER_NAME = 'MSD_TWO_LEVEL_PLANNING'
AND PROD.INVENTORY_ITEM_ID = ITM.INVENTORY_ITEM_ID
AND PROD.ORGANIZATION_ID = ITM.ORGANIZATION_ID
AND APP.ORGANIZATION_ID = PROD.ORGANIZATION_ID
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
, PROD.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'))
AND PROD.ORGANIZATION_ID=ODJ.ORGANIZATION_ID
AND PROD.JOB_ID= ODJ.JOB_ID
AND PROD.JOB_TYPE=ODJ.JOB_TYPE
AND PROD.INVENTORY_ITEM_ID=ODJ.ASSEMBLY_ITEM_ID
AND PROD.LINE_TYPE =ODJ.LINE_TYPE