eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_GET_NAME dependencies on MSC_ITEM_CATEGORIES

Line 2415: category_description msc_item_categories.description%type;

2411: arg_category_set_id IN NUMBER,
2412: arg_org_id IN NUMBER,
2413: arg_instance_id IN NUMBER) return varchar2 IS
2414:
2415: category_description msc_item_categories.description%type;
2416:
2417: CURSOR category_desc_org IS
2418: SELECT description
2419: FROM msc_item_categories

Line 2419: FROM msc_item_categories

2415: category_description msc_item_categories.description%type;
2416:
2417: CURSOR category_desc_org IS
2418: SELECT description
2419: FROM msc_item_categories
2420: WHERE category_set_id = arg_category_set_id
2421: AND category_name = arg_category_name
2422: AND sr_instance_id = arg_instance_id
2423: AND organization_id = arg_org_id

Line 2429: FROM msc_item_categories

2425: AND rownum<2;
2426:
2427: CURSOR category_desc_ins IS
2428: SELECT description
2429: FROM msc_item_categories
2430: WHERE category_set_id = arg_category_set_id
2431: AND category_name = arg_category_name
2432: AND sr_instance_id = arg_instance_id
2433: AND description is NOT NULL

Line 2438: FROM msc_item_categories

2434: AND rownum<2;
2435:
2436: CURSOR category_desc IS
2437: SELECT description
2438: FROM msc_item_categories
2439: WHERE category_set_id = arg_category_set_id
2440: AND category_name = arg_category_name
2441: AND description is NOT NULL
2442: AND rownum<2;

Line 2791: category_name msc_item_categories.category_name%type;

2787: arg_category_set_id IN NUMBER,
2788: arg_org_id IN NUMBER default null,
2789: arg_instance_id IN NUMBER default null) return varchar2 IS
2790:
2791: category_name msc_item_categories.category_name%type;
2792:
2793: CURSOR category_name_org IS
2794: SELECT category_name
2795: FROM msc_item_categories

Line 2795: FROM msc_item_categories

2791: category_name msc_item_categories.category_name%type;
2792:
2793: CURSOR category_name_org IS
2794: SELECT category_name
2795: FROM msc_item_categories
2796: WHERE category_set_id = arg_category_set_id
2797: AND sr_category_id = arg_category_id
2798: AND sr_instance_id = arg_instance_id
2799: AND organization_id = arg_org_id

Line 2805: FROM msc_item_categories

2801: AND rownum<2;
2802:
2803: CURSOR category_name_ins IS
2804: SELECT category_name
2805: FROM msc_item_categories
2806: WHERE category_set_id = decode(arg_category_set_id, -1, category_set_id, arg_category_set_id)
2807: AND sr_category_id= arg_category_id
2808: AND sr_instance_id = arg_instance_id
2809: AND description is NOT NULL

Line 2814: FROM msc_item_categories

2810: AND rownum<2;
2811:
2812: CURSOR category_name_c IS
2813: SELECT category_name
2814: FROM msc_item_categories
2815: WHERE category_set_id = arg_category_set_id
2816: AND sr_category_id= arg_category_id
2817: AND description is NOT NULL
2818: AND rownum<2;

Line 2950: from msc_item_categories

2946: p_org_id in number,
2947: p_inst_id in number) return number is
2948: cursor category_id_c is
2949: select sr_category_id
2950: from msc_item_categories
2951: where category_name = p_category_name
2952: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
2953: and rownum =1 ;
2954:

Line 2958: from msc_item_categories

2954:
2955:
2956: cursor category_id_c1 is
2957: select sr_category_id
2958: from msc_item_categories
2959: where category_name = p_category_name
2960: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
2961: and organization_id=p_org_id
2962: and sr_instance_id=p_inst_id

Line 3261: from msc_item_categories

3257: p_instance_id number) return number is
3258: l_cat_set_id number;
3259: cursor cat_set_id_c is
3260: select sr_category_id
3261: from msc_item_categories
3262: where inventory_item_id=p_inventory_item_id
3263: and sr_instance_id=p_instance_id
3264: and organization_id=decode(p_organization_id, -1,organization_id, p_organization_id)
3265: and rownum < 2;

Line 3284: from msc_item_categories

3280:
3281: l_cat_id number;
3282: cursor cat_id_c is
3283: select category_set_id
3284: from msc_item_categories
3285: where inventory_item_id=p_inventory_item_id
3286: and sr_instance_id=p_instance_id
3287: and organization_id=decode(p_organization_id, -1, organization_id, p_organization_id)
3288: and rownum < 2;