APPS.MSD_DEM_SOP dependencies on MSD_DEM_SR_UTIL

Line 2164: || ' (select msd_dem_sr_util.get_null_code default_code from dual) dfu '

2160: || ' null PROD_PLAN, null REQUIRED_SUPPLIER_CAP, null REQUIRED_RES_PLAN, null BEGINNING_ONHAND, '
2161: || ' CONSTRAINED_FCST, DEPENDENT_DEMAND, PLANNED_SHIPMENTS, null INTRANSIT_DEFECTIVES, '
2162: || ' null BEGINNING_ONHAND_DEFECTIVES, WORK_ORDER_DEMAND'
2163: || ' from MSD_ST_SOP_WO_DEMANDS, '
2164: || ' (select msd_dem_sr_util.get_null_code default_code from dual) dfu '
2165: || ' UNION ALL '
2166: || ' select SDATE, ASSET_GROUP, CLASS_CODE, RESOURCE_CODE ITEM_CODE, ORGANIZATION_CODE, dfu.default_code site_code, '
2167: || ' null PROD_PLAN, null REQUIRED_SUPPLIER_CAP, REQUIRED_RES_PLAN, null BEGINNING_ONHAND, '
2168: || ' null CONSTRAINED_FCST, null DEPENDENT_DEMAND, null PLANNED_SHIPMENTS, null INTRANSIT_DEFECTIVES, '

Line 2171: || ' (select msd_dem_sr_util.get_null_code default_code from dual) dfu '

2167: || ' null PROD_PLAN, null REQUIRED_SUPPLIER_CAP, REQUIRED_RES_PLAN, null BEGINNING_ONHAND, '
2168: || ' null CONSTRAINED_FCST, null DEPENDENT_DEMAND, null PLANNED_SHIPMENTS, null INTRANSIT_DEFECTIVES, '
2169: || ' null BEGINNING_ONHAND_DEFECTIVES, null WORK_ORDER_DEMAND'
2170: || ' from MSD_ST_SOP_WO_REQR_RES_CAP, '
2171: || ' (select msd_dem_sr_util.get_null_code default_code from dual) dfu '
2172: || ' UNION ALL '
2173: || ' select SDATE, ASSET_GROUP, CLASS_CODE, ITEM_CODE, ORGANIZATION_CODE, SITE_CODE, '
2174: || ' PROD_PLAN, REQUIRED_SUPPLIER_CAP, null REQUIRED_RES_PLAN, BEGINNING_ONHAND, '
2175: || ' null CONSTRAINED_FCST, null DEPENDENT_DEMAND, null PLANNED_SHIPMENTS, INTRANSIT_DEFECTIVES, '

Line 2179: || ' (select msd_dem_sr_util.get_null_code default_code from dual) du '

2175: || ' null CONSTRAINED_FCST, null DEPENDENT_DEMAND, null PLANNED_SHIPMENTS, INTRANSIT_DEFECTIVES, '
2176: || ' BEGINNING_ONHAND_DEFECTIVES, null WORK_ORDER_DEMAND'
2177: || ' from MSD_ST_SOP_WO_SUPPLIES '
2178: || ' ) data, '
2179: || ' (select msd_dem_sr_util.get_null_code default_code from dual) du '
2180: || ' group by '
2181: || ' SDATE, :2, ASSET_GROUP, CLASS_CODE, ITEM_CODE, ORGANIZATION_CODE, '
2182: || ' du.default_code, SITE_CODE, du.default_code';
2183:

Line 3393: ||' WHERE LEVEL3 <> ''' || msd_dem_sr_util.get_null_code || ''' ';

3389: ||' set level3 = ( select mtp.partner_id '
3390: ||' from msc_trading_partners mtp '
3391: ||' where mtp.partner_name = bsb.level3 '
3392: ||' and mtp.partner_type = 2 )'
3393: ||' WHERE LEVEL3 <> ''' || msd_dem_sr_util.get_null_code || ''' ';
3394:
3395: msd_dem_common_utilities.log_message(l_sql_stmnt);
3396:
3397: begin

Line 3406: || ' SET level3 = ''' || msd_dem_sr_util.get_null_code || ''' '

3402: end;
3403: END IF;
3404:
3405: l_sql_stmnt := ' UPDATE ' || x_dest_table
3406: || ' SET level3 = ''' || msd_dem_sr_util.get_null_code || ''' '
3407: || ' WHERE level3 IS NULL ';
3408:
3409: msd_dem_common_utilities.log_message(l_sql_stmnt);
3410: