DBA Data[Home] [Help]

APPS.INVIDSCS dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 28: from MTL_DEFAULT_CATEGORY_SETS MDCS

24: null;
25:
26: BEGIN
27: select 'X' into temp
28: from MTL_DEFAULT_CATEGORY_SETS MDCS
29: where MDCS.category_set_id = current_cat_set_id
30: and MDCS.functional_area_id = 1;
31: /*If no data found then set flag to 'N'*/
32: func_area_flag1 := 'Y';

Line 40: from MTL_DEFAULT_CATEGORY_SETS MDCS

36: END;
37:
38: BEGIN
39: select 'X' into temp
40: from MTL_DEFAULT_CATEGORY_SETS MDCS
41: where MDCS.category_set_id = current_cat_set_id
42: and MDCS.functional_area_id = 2;
43: /*If no data found then set flag to 'N'*/
44: func_area_flag2 := 'Y';

Line 52: from MTL_DEFAULT_CATEGORY_SETS MDCS

48: END;
49:
50: BEGIN
51: select 'X' into temp
52: from MTL_DEFAULT_CATEGORY_SETS MDCS
53: where MDCS.category_set_id = current_cat_set_id
54: and MDCS.functional_area_id = 3;
55: /*If no data found then set flag to 'N'*/
56: func_area_flag3 := 'Y';

Line 64: from MTL_DEFAULT_CATEGORY_SETS MDCS

60: END;
61:
62: BEGIN
63: select 'X' into temp
64: from MTL_DEFAULT_CATEGORY_SETS MDCS
65: where MDCS.category_set_id = current_cat_set_id
66: and MDCS.functional_area_id = 4;
67: /*If no data found then set flag to 'N'*/
68: func_area_flag4 := 'Y';

Line 76: from MTL_DEFAULT_CATEGORY_SETS MDCS

72: END;
73:
74: BEGIN
75: select 'X' into temp
76: from MTL_DEFAULT_CATEGORY_SETS MDCS
77: where MDCS.category_set_id = current_cat_set_id
78: and MDCS.functional_area_id = 5;
79: /*If no data found then set flag to 'N'*/
80: func_area_flag5 := 'Y';

Line 88: from MTL_DEFAULT_CATEGORY_SETS MDCS

84: END;
85:
86: BEGIN
87: select 'X' into temp
88: from MTL_DEFAULT_CATEGORY_SETS MDCS
89: where MDCS.category_set_id = current_cat_set_id
90: and MDCS.functional_area_id = 6;
91: /*If no data found then set flag to 'N'*/
92: func_area_flag6 := 'Y';

Line 100: from MTL_DEFAULT_CATEGORY_SETS MDCS

96: END;
97:
98: BEGIN
99: select 'X' into temp
100: from MTL_DEFAULT_CATEGORY_SETS MDCS
101: where MDCS.category_set_id = current_cat_set_id
102: and MDCS.functional_area_id = 7;
103: /*If no data found then set flag to 'N'*/
104: func_area_flag7 := 'Y';

Line 112: from MTL_DEFAULT_CATEGORY_SETS MDCS

108: END;
109: --Bug : 2527058 Added
110: BEGIN
111: select 'X' into temp
112: from MTL_DEFAULT_CATEGORY_SETS MDCS
113: where MDCS.category_set_id = current_cat_set_id
114: and MDCS.functional_area_id = 8;
115: /*If no data found then set flag to 'N'*/
116: func_area_flag8 := 'Y';

Line 124: from MTL_DEFAULT_CATEGORY_SETS MDCS

120: END;
121:
122: BEGIN
123: select 'X' into temp
124: from MTL_DEFAULT_CATEGORY_SETS MDCS
125: where MDCS.category_set_id = current_cat_set_id
126: and MDCS.functional_area_id = 9;
127: /*If no data found then set flag to 'N'*/
128: func_area_flag9 := 'Y';

Line 136: from MTL_DEFAULT_CATEGORY_SETS MDCS

132: END;
133:
134: BEGIN
135: select 'X' into temp
136: from MTL_DEFAULT_CATEGORY_SETS MDCS
137: where MDCS.category_set_id = current_cat_set_id
138: and MDCS.functional_area_id = 10;
139: /*If no data found then set flag to 'N'*/
140: func_area_flag10 := 'Y';

Line 148: from MTL_DEFAULT_CATEGORY_SETS MDCS

144: END;
145:
146: BEGIN
147: select 'X' into temp
148: from MTL_DEFAULT_CATEGORY_SETS MDCS
149: where MDCS.category_set_id = current_cat_set_id
150: and MDCS.functional_area_id = 11;
151: /*If no data found then set flag to 'N'*/
152: func_area_flag11 := 'Y';

Line 388: from mtl_default_category_sets

384:
385: -- get default category set for Costing (functional area 5)
386: select category_set_id
387: into tmp_default_cat_set_id
388: from mtl_default_category_sets
389: where functional_area_id = 5;
390:
391: -- This is called from post-update.
392: -- fires only after update is done. if updated, and if cat set id