APPS.MSC_UI_PEG_UTIL dependencies on MSC_GET_NAME

Line 45: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(ms.organization_id,ms.sr_instance_id)

41: l_prev_peg_id NUMBER;
42: i NUMBER;
43:
44: cursor cur1(p_disposition_id_1 number , l_show_item_desc number) is
45: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(ms.organization_id,ms.sr_instance_id)
46: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(ms.organization_id,ms.sr_instance_id) ) item_org,
47: ms.new_order_quantity supply_qty,
48: ms.new_schedule_date supply_date,
49: msc_get_name.lookup_meaning( 'MRP_ORDER_TYPE',

Line 46: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(ms.organization_id,ms.sr_instance_id) ) item_org,

42: i NUMBER;
43:
44: cursor cur1(p_disposition_id_1 number , l_show_item_desc number) is
45: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(ms.organization_id,ms.sr_instance_id)
46: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(ms.organization_id,ms.sr_instance_id) ) item_org,
47: ms.new_order_quantity supply_qty,
48: ms.new_schedule_date supply_date,
49: msc_get_name.lookup_meaning( 'MRP_ORDER_TYPE',
50: decode(ms.order_type,92,70,ms.order_type)) order_name,

Line 49: msc_get_name.lookup_meaning( 'MRP_ORDER_TYPE',

45: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(ms.organization_id,ms.sr_instance_id)
46: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(ms.organization_id,ms.sr_instance_id) ) item_org,
47: ms.new_order_quantity supply_qty,
48: ms.new_schedule_date supply_date,
49: msc_get_name.lookup_meaning( 'MRP_ORDER_TYPE',
50: decode(ms.order_type,92,70,ms.order_type)) order_name,
51: null pegging_id,
52: null prev_pegging_id,
53: ms.transaction_id,

Line 299: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)

295: item_id, item_org,item_desc_org, order_type, end_disposition
296: order by item_org, demand_date;
297:
298: cursor cur2(l_show_item_desc number) is
299: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)
300: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) ) item_org,
301: dm.using_requirement_quantity demand_qty,
302: dm.using_assembly_demand_date demand_date,
303: msc_get_name.lookup_meaning( 'MSC_DEMAND_ORIGINATION',

Line 300: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) ) item_org,

296: order by item_org, demand_date;
297:
298: cursor cur2(l_show_item_desc number) is
299: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)
300: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) ) item_org,
301: dm.using_requirement_quantity demand_qty,
302: dm.using_assembly_demand_date demand_date,
303: msc_get_name.lookup_meaning( 'MSC_DEMAND_ORIGINATION',
304: decode(dm.origination_type,92,50,dm.origination_type)) origination_name,

Line 303: msc_get_name.lookup_meaning( 'MSC_DEMAND_ORIGINATION',

299: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)
300: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id) ) item_org,
301: dm.using_requirement_quantity demand_qty,
302: dm.using_assembly_demand_date demand_date,
303: msc_get_name.lookup_meaning( 'MSC_DEMAND_ORIGINATION',
304: decode(dm.origination_type,92,50,dm.origination_type)) origination_name,
305: null prev_pegging_id,
306: dm.demand_id demand_id,
307: dm.using_requirement_quantity pegged_qty,

Line 605: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)

601: p_show_item_desc IN NUMBER DEFAULT 2) IS
602: i number;
603:
604: Cursor cur1(l_show_item_desc number) is
605: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)
606: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)) item_org,
607: dm.using_requirement_quantity demand_qty,
608: dm.using_assembly_demand_date demand_date,
609: msc_get_name.lookup_meaning( 'MSC_DEMAND_ORIGINATION',

Line 606: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)) item_org,

602: i number;
603:
604: Cursor cur1(l_show_item_desc number) is
605: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)
606: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)) item_org,
607: dm.using_requirement_quantity demand_qty,
608: dm.using_assembly_demand_date demand_date,
609: msc_get_name.lookup_meaning( 'MSC_DEMAND_ORIGINATION',
610: decode(dm.origination_type,92,50,dm.origination_type)) origination_name,

Line 609: msc_get_name.lookup_meaning( 'MSC_DEMAND_ORIGINATION',

605: select decode(l_show_item_desc, 1, substrb(nvl(mis.description,mis.item_name),1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)
606: ,substrb(mis.item_name,1,80)||'/'||msc_get_name.org_code(dm.organization_id,dm.sr_instance_id)) item_org,
607: dm.using_requirement_quantity demand_qty,
608: dm.using_assembly_demand_date demand_date,
609: msc_get_name.lookup_meaning( 'MSC_DEMAND_ORIGINATION',
610: decode(dm.origination_type,92,50,dm.origination_type)) origination_name,
611: null prev_pegging_id,
612: dm.demand_id demand_id,
613: dm.using_requirement_quantity pegged_qty,