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.MSD_PRICE_LIST_PP dependencies on MSD_ST_PRICE_LIST

Line 13: from msd_st_price_list a

9:
10: CURSOR c_multi_price_list (p_instance_id in varchar2,
11: p_price_list in varchar2 ) IS
12: select price_list_name, sr_product_lvl_pk, start_date, end_date
13: from msd_st_price_list a
14: where instance = p_instance_id
15: and price_list_name like nvl(p_price_list, price_list_name)
16: and not exists (select 1 from msd_st_price_list b
17: where b.instance = a.instance

Line 16: and not exists (select 1 from msd_st_price_list b

12: select price_list_name, sr_product_lvl_pk, start_date, end_date
13: from msd_st_price_list a
14: where instance = p_instance_id
15: and price_list_name like nvl(p_price_list, price_list_name)
16: and not exists (select 1 from msd_st_price_list b
17: where b.instance = a.instance
18: and b.price_list_name = a.price_list_name
19: and nvl(b.start_date, to_date('01/01/1000', 'MM/DD/YYYY')) = nvl(a.start_date, to_date('01/01/1000', 'MM/DD/YYYY'))
20: and nvl(b.end_date, to_date('01/01/1000', 'MM/DD/YYYY')) = nvl(a.end_date, to_date('01/01/1000', 'MM/DD/YYYY'))

Line 31: from msd_st_price_list

27:
28: CURSOR c_single_price_list (p_instance_id in varchar2,
29: p_price_list in varchar2 ) IS
30: select price_list_name, sr_product_lvl_pk, start_date, end_date
31: from msd_st_price_list
32: where instance = p_instance_id
33: and price_list_name like nvl(p_price_list, price_list_name)
34: and nvl(valid_flag, 0) <> 1
35: group by price_list_name, sr_product_lvl_pk, start_date, end_date

Line 39: type price_list_name_tab is table of msd_st_price_list.price_list_name%type;

35: group by price_list_name, sr_product_lvl_pk, start_date, end_date
36: having count(*) = 1;
37:
38:
39: type price_list_name_tab is table of msd_st_price_list.price_list_name%type;
40: TYPE sr_product_lvl_pk_tab is table of msd_st_price_list.sr_product_lvl_pk%TYPE;
41: type start_date_tab is table of msd_st_price_list.start_date%type;
42: type end_date_tab is table of msd_st_price_list.end_date%type;
43:

Line 40: TYPE sr_product_lvl_pk_tab is table of msd_st_price_list.sr_product_lvl_pk%TYPE;

36: having count(*) = 1;
37:
38:
39: type price_list_name_tab is table of msd_st_price_list.price_list_name%type;
40: TYPE sr_product_lvl_pk_tab is table of msd_st_price_list.sr_product_lvl_pk%TYPE;
41: type start_date_tab is table of msd_st_price_list.start_date%type;
42: type end_date_tab is table of msd_st_price_list.end_date%type;
43:
44:

Line 41: type start_date_tab is table of msd_st_price_list.start_date%type;

37:
38:
39: type price_list_name_tab is table of msd_st_price_list.price_list_name%type;
40: TYPE sr_product_lvl_pk_tab is table of msd_st_price_list.sr_product_lvl_pk%TYPE;
41: type start_date_tab is table of msd_st_price_list.start_date%type;
42: type end_date_tab is table of msd_st_price_list.end_date%type;
43:
44:
45: a_price_list_name price_list_name_tab;

Line 42: type end_date_tab is table of msd_st_price_list.end_date%type;

38:
39: type price_list_name_tab is table of msd_st_price_list.price_list_name%type;
40: TYPE sr_product_lvl_pk_tab is table of msd_st_price_list.sr_product_lvl_pk%TYPE;
41: type start_date_tab is table of msd_st_price_list.start_date%type;
42: type end_date_tab is table of msd_st_price_list.end_date%type;
43:
44:
45: a_price_list_name price_list_name_tab;
46: a_sr_product_lvl_pk sr_product_lvl_pk_tab;

Line 65: update msd_st_price_list

61:
62: IF a_price_list_name.exists(1) THEN
63:
64: FORALL i IN a_price_list_name.FIRST..a_price_list_name.LAST
65: update msd_st_price_list
66: set valid_flag = 1
67: where price_list_uom = (select base_uom
68: from msd_item_list_price
69: where sr_item_pk = a_sr_product_lvl_pk(i)

Line 87: update msd_st_price_list

83: CLOSE c_multi_price_list;
84:
85: IF a_price_list_name.exists(1) THEN
86: FORALL i IN a_price_list_name.FIRST..a_price_list_name.LAST
87: update msd_st_price_list
88: set valid_flag = 1
89: where primary_uom_flag = 'Y'
90: and instance = p_instance_id
91: and price_list_name = a_price_list_name(i)

Line 108: update msd_st_price_list

104: CLOSE c_multi_price_list;
105:
106: IF a_price_list_name.exists(1) THEN
107: FORALL i IN a_price_list_name.FIRST..a_price_list_name.LAST
108: update msd_st_price_list
109: set valid_flag = 1
110: where instance = p_instance_id
111: and price_list_name = a_price_list_name(i)
112: and sr_product_lvl_pk = a_sr_product_lvl_pk(i)

Line 114: from msd_st_price_list b

110: where instance = p_instance_id
111: and price_list_name = a_price_list_name(i)
112: and sr_product_lvl_pk = a_sr_product_lvl_pk(i)
113: and nvl(priority, -999) = (select nvl(min(b.priority), -999)
114: from msd_st_price_list b
115: where b.price_list_name = a_price_list_name(i)
116: and b.sr_product_lvl_pk = a_sr_product_lvl_pk(i)
117: and nvl(b.start_date, to_date('01/01/1000', 'MM/DD/YYYY')) = nvl(a_start_date(i), to_date('01/01/1000', 'MM/DD/YYYY'))
118: and nvl(b.end_date, to_date('01/01/1000', 'MM/DD/YYYY')) = nvl(a_end_date(i), to_date('01/01/1000', 'MM/DD/YYYY'))

Line 138: update msd_st_price_list

134:
135: IF a_price_list_name.exists(1) THEN
136:
137: FORALL i IN a_price_list_name.FIRST..a_price_list_name.LAST
138: update msd_st_price_list
139: set valid_flag = 1
140: where instance = p_instance_id
141: and price_list_name = a_price_list_name(i)
142: and sr_product_lvl_pk = a_sr_product_lvl_pk(i)

Line 150: delete from msd_st_price_list

146: END IF;
147:
148: /* delete all dublicate price list lines which is not set to valid flag to 1 */
149:
150: delete from msd_st_price_list
151: where instance = p_instance_id
152: and price_list_name like nvl(p_price_list, price_list_name)
153: and nvl(valid_flag,0) <> 1;
154: