APPS.MSC_PEG_UTIL dependencies on MSC_GET_NAME

Line 54: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id) item_org,

50: -- This case is when you are on Production Forecast and you expand a Demand Tree meaning
51: -- u are pegging up so the next node should be Product Family Planned Order
52: IF l_origination_type = 22 THEN
53: select mis.item_name ||'/'||
54: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id) item_org,
55: ms.new_order_quantity supply_qty,
56: ms.new_schedule_date supply_date,
57: msc_get_name.lookup_meaning( 'MRP_ORDER_TYPE',
58: ms.order_type) order_name,

Line 57: msc_get_name.lookup_meaning( 'MRP_ORDER_TYPE',

53: select mis.item_name ||'/'||
54: msc_get_name.org_code(ms.organization_id,ms.sr_instance_id) item_org,
55: ms.new_order_quantity supply_qty,
56: ms.new_schedule_date supply_date,
57: msc_get_name.lookup_meaning( 'MRP_ORDER_TYPE',
58: ms.order_type) order_name,
59: null pegging_id,
60: null prev_pegging_id,
61: ms.transaction_id,

Line 297: msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) item_org,

293:
294: ELSIF p_supply_pegging = 1 and l_bom_item_type = 5 then
295: -- this case is for Product Family , we need to display the Product Forecast nodes when node is expanded
296: select mis.item_name ||'/'||
297: msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) item_org,
298: dm.using_requirement_quantity demand_qty,
299: dm.using_assembly_demand_date demand_date,
300: msc_get_name.lookup_meaning( 'MRP_DEMAND_ORIGINATION',
301: dm.origination_type) origination_name,

Line 300: msc_get_name.lookup_meaning( 'MRP_DEMAND_ORIGINATION',

296: select mis.item_name ||'/'||
297: msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) item_org,
298: dm.using_requirement_quantity demand_qty,
299: dm.using_assembly_demand_date demand_date,
300: msc_get_name.lookup_meaning( 'MRP_DEMAND_ORIGINATION',
301: dm.origination_type) origination_name,
302: null prev_pegging_id,
303: dm.demand_id demand_id,
304: dm.using_requirement_quantity pegged_qty,

Line 423: msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) item_org,

419: IF p_bom_item_type in (1, 2) THEN -- this means we just want to get Prod.Forecast of Options when we
420:
421: -- drill down from ATO Model with Forecast control set to NONE
422: select mis.item_name ||'/'||
423: msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) item_org,
424: dm.using_requirement_quantity demand_qty,
425: dm.using_assembly_demand_date demand_date,
426: msc_get_name.lookup_meaning( 'MRP_DEMAND_ORIGINATION',
427: dm.origination_type) origination_name,

Line 426: msc_get_name.lookup_meaning( 'MRP_DEMAND_ORIGINATION',

422: select mis.item_name ||'/'||
423: msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) item_org,
424: dm.using_requirement_quantity demand_qty,
425: dm.using_assembly_demand_date demand_date,
426: msc_get_name.lookup_meaning( 'MRP_DEMAND_ORIGINATION',
427: dm.origination_type) origination_name,
428: null prev_pegging_id,
429: dm.demand_id demand_id,
430: dm.using_requirement_quantity pegged_qty,