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 2817: category_description msc_item_categories.description%type;

2813: arg_category_set_id IN NUMBER,
2814: arg_org_id IN NUMBER,
2815: arg_instance_id IN NUMBER) return varchar2 IS
2816:
2817: category_description msc_item_categories.description%type;
2818:
2819: CURSOR category_desc_org IS
2820: SELECT description
2821: FROM msc_item_categories

Line 2821: FROM msc_item_categories

2817: category_description msc_item_categories.description%type;
2818:
2819: CURSOR category_desc_org IS
2820: SELECT description
2821: FROM msc_item_categories
2822: WHERE category_set_id = arg_category_set_id
2823: AND category_name = arg_category_name
2824: AND sr_instance_id = arg_instance_id
2825: AND organization_id = arg_org_id

Line 2831: FROM msc_item_categories

2827: AND rownum<2;
2828:
2829: CURSOR category_desc_ins IS
2830: SELECT description
2831: FROM msc_item_categories
2832: WHERE category_set_id = arg_category_set_id
2833: AND category_name = arg_category_name
2834: AND sr_instance_id = arg_instance_id
2835: AND description is NOT NULL

Line 2840: FROM msc_item_categories

2836: AND rownum<2;
2837:
2838: CURSOR category_desc IS
2839: SELECT description
2840: FROM msc_item_categories
2841: WHERE category_set_id = arg_category_set_id
2842: AND category_name = arg_category_name
2843: AND description is NOT NULL
2844: AND rownum<2;

Line 3193: category_name msc_item_categories.category_name%type;

3189: arg_category_set_id IN NUMBER,
3190: arg_org_id IN NUMBER default null,
3191: arg_instance_id IN NUMBER default null) return varchar2 IS
3192:
3193: category_name msc_item_categories.category_name%type;
3194:
3195: CURSOR category_name_org IS
3196: SELECT category_name
3197: FROM msc_item_categories

Line 3197: FROM msc_item_categories

3193: category_name msc_item_categories.category_name%type;
3194:
3195: CURSOR category_name_org IS
3196: SELECT category_name
3197: FROM msc_item_categories
3198: WHERE category_set_id = arg_category_set_id
3199: AND sr_category_id = arg_category_id
3200: AND sr_instance_id = arg_instance_id
3201: AND organization_id = arg_org_id

Line 3207: FROM msc_item_categories

3203: AND rownum<2;
3204:
3205: CURSOR category_name_ins IS
3206: SELECT category_name
3207: FROM msc_item_categories
3208: WHERE category_set_id = decode(arg_category_set_id, -1, category_set_id, arg_category_set_id)
3209: AND sr_category_id= arg_category_id
3210: AND sr_instance_id = arg_instance_id
3211: AND description is NOT NULL

Line 3216: FROM msc_item_categories

3212: AND rownum<2;
3213:
3214: CURSOR category_name_c IS
3215: SELECT category_name
3216: FROM msc_item_categories
3217: WHERE category_set_id = arg_category_set_id
3218: AND sr_category_id= arg_category_id
3219: AND description is NOT NULL
3220: AND rownum<2;

Line 3224: FROM msc_item_categories

3220: AND rownum<2;
3221:
3222: CURSOR cur_category_name IS
3223: SELECT category_name
3224: FROM msc_item_categories
3225: WHERE sr_category_id= arg_category_id
3226: AND description is NOT NULL
3227: AND rownum<2;
3228: BEGIN

Line 3363: from msc_item_categories

3359: p_org_id in number,
3360: p_inst_id in number) return number is
3361: cursor category_id_c is
3362: select sr_category_id
3363: from msc_item_categories
3364: where category_name = p_category_name
3365: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
3366: and rownum =1 ;
3367:

Line 3371: from msc_item_categories

3367:
3368:
3369: cursor category_id_c1 is
3370: select sr_category_id
3371: from msc_item_categories
3372: where category_name = p_category_name
3373: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
3374: and organization_id=p_org_id
3375: and sr_instance_id=p_inst_id

Line 3380: from msc_item_categories

3376: and rownum =1 ;
3377:
3378: cursor category_id_inst is
3379: select sr_category_id
3380: from msc_item_categories
3381: where category_name = p_category_name
3382: and category_set_id = fnd_profile.value('MSR_BUDGET_CATEGORY_SET')
3383: and sr_instance_id=p_inst_id
3384: and rownum =1 ;

Line 3691: from msc_item_categories

3687: p_instance_id number) return number is
3688: l_cat_set_id number;
3689: cursor cat_set_id_c is
3690: select sr_category_id
3691: from msc_item_categories
3692: where inventory_item_id=p_inventory_item_id
3693: and sr_instance_id=p_instance_id
3694: and organization_id=decode(p_organization_id, -1,organization_id, p_organization_id)
3695: and rownum < 2;

Line 3714: from msc_item_categories

3710:
3711: l_cat_id number;
3712: cursor cat_id_c is
3713: select category_set_id
3714: from msc_item_categories
3715: where inventory_item_id=p_inventory_item_id
3716: and sr_instance_id=p_instance_id
3717: and organization_id=decode(p_organization_id, -1, organization_id, p_organization_id)
3718: and rownum < 2;