APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_GET_NAME

Line 2822: ':p_total_member_string || msc_get_name.item_name(msi.product_family_id,null,null,null) '||

2818: 'DECODE( :p_org_id,-1,-1,msi.organization_id), '||
2819: ' :NODE_REGULAR_ITEM, '||
2820: ' :org_seq, '||
2821: 'DECODE( :p_org_id,-1,:p_all_org_string ,msi.organization_code), '||
2822: ':p_total_member_string || msc_get_name.item_name(msi.product_family_id,null,null,null) '||
2823: ' FROM msc_items_tree_v msi' ||
2824: ' WHERE msi.category_set_id = :p_category_set ' ||
2825: ' AND msi.product_family_id = :p_item_list ' ||
2826: ' AND msi.plan_id = :p_plan_id';

Line 2909: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id), '||

2905: 'msi.inventory_item_id, '||
2906: 'msi.organization_id, '||
2907: ':NODE_REGULAR_ITEM, ' ||
2908: ' :org_seq, '||
2909: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id), '||
2910: 'msi.item_name '||
2911: ' FROM msc_system_items msi ' ||
2912: ' where msi.sr_instance_id = :p_inst_id '||
2913: 'and msi.organization_id = :p_org_list ' ||

Line 2957: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||

2953: 'msi.inventory_item_id,'||
2954: 'msi.organization_id, '||
2955: ' :NODE_REGULAR_ITEM, ' ||
2956: ' :org_seq, '||
2957: 'msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||
2958: 'msi.item_name '||
2959: ' FROM msc_system_items msi, msc_item_categories mic' ||
2960: ' WHERE mic.organization_id = msi.organization_id ' ||
2961: 'AND mic.sr_instance_id = msi.sr_instance_id ' ||

Line 2977: ' msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||

2973: 'msi.inventory_item_id,'||
2974: 'msi.organization_id, '||
2975: ' :NODE_REGULAR_ITEM, ' ||
2976: ' :org_seq, '||
2977: ' msc_get_name.org_code(msi.organization_id,msi.sr_instance_id),'||
2978: ' msi.item_name '||
2979: ' FROM msc_system_items msi ' ||
2980: ' where msi.inventory_item_id = :p_item_list ' ||
2981: ' AND msi.organization_id <> -1 '||

Line 3367: ' FROM '||msc_get_name.get_order_view(p_plan_type, p_plan_id) ||

3363: else -- regular item
3364: sql_stmt := '';
3365: sql_stmt := sql_stmt_1 ||
3366: ' transaction_id '||
3367: ' FROM '||msc_get_name.get_order_view(p_plan_type, p_plan_id) ||
3368: ' WHERE plan_id = :p_plan_id' ||
3369: ' AND organization_id = :p_org_id'||
3370: ' AND sr_instance_id = :p_inst_id'||
3371: ' and inventory_item_id = :p_item_id';