APPS.MSC_IMPORT_ONHAND dependencies on MSC_ST_DEMANDS

Line 13: -- all the fields in the msc_st_demands tables with the mapped supplier

9: IS
10: l_user_id number := fnd_global.user_id;
11: BEGIN
12: -- Now for another kludge. First thing that we will do is to update
13: -- all the fields in the msc_st_demands tables with the mapped supplier
14: -- codes on the exchange
15: -- Rob, please check and then run into the database as soon as Bala
16: -- Desikan gives us the mapping codes
17: /*

Line 18: update msc_st_demands

14: -- codes on the exchange
15: -- Rob, please check and then run into the database as soon as Bala
16: -- Desikan gives us the mapping codes
17: /*
18: update msc_st_demands
19: set attribute1 = decode(attribute1,'F159B','',
20: 'T407H','',
21: 'U0WRC','',
22: 'EE02A','',

Line 35: update MSC_ST_DEMANDS

31: where attribute11 = 'NEW'
32: and attribute8 in ('ONHAND','FORECAST');
33: */
34: -- Validate Buyer Code
35: update MSC_ST_DEMANDS
36: set ATTRIBUTE11 = 'ERROR',
37: ATTRIBUTE15 = 'Invalid Buyer Code'
38: where not exists ( select 'exists'
39: from HZ_PARTIES HP,

Line 40: MSC_ST_DEMANDS MSD

36: set ATTRIBUTE11 = 'ERROR',
37: ATTRIBUTE15 = 'Invalid Buyer Code'
38: where not exists ( select 'exists'
39: from HZ_PARTIES HP,
40: MSC_ST_DEMANDS MSD
41: where HP.PARTY_NAME = MSD.ATTRIBUTE1
42: and HP.PARTY_TYPE = 'ORGANIZATION')
43: and ATTRIBUTE11 = 'NEW'
44: and ATTRIBUTE8 = 'ONHAND';

Line 47: update MSC_ST_DEMANDS

43: and ATTRIBUTE11 = 'NEW'
44: and ATTRIBUTE8 = 'ONHAND';
45:
46: -- Validate Quantity
47: update MSC_ST_DEMANDS
48: set ATTRIBUTE11 = 'ERROR',
49: ATTRIBUTE15 = 'Invalid Quantity'
50: where ATTRIBUTE11 = 'NEW'
51: and ATTRIBUTE8 = 'ONHAND'

Line 70: from MSC_ST_DEMANDS MSD

66: l_user_id,
67: SYSDATE,
68: l_user_id
69: from (select distinct MSD.ATTRIBUTE3 , MSD.ATTRIBUTE13
70: from MSC_ST_DEMANDS MSD
71: where MSD.ATTRIBUTE11 = 'NEW'
72: and MSD.ATTRIBUTE8 = 'ONHAND'
73: and not exists (select 'exists'
74: from msc_items item

Line 119: from MSC_ST_DEMANDS MSD,

115: MSD.ATTRIBUTE9,
116: MSD.ATTRIBUTE10,
117: hp.party_id,
118: mi.inventory_item_id
119: from MSC_ST_DEMANDS MSD,
120: hz_parties hp,
121: msc_items mi
122: where mi.item_name = MSD.ATTRIBUTE3
123: and MSD.ATTRIBUTE1 = hp.party_name

Line 129: from MSC_ST_DEMANDS,

125: and MSD.ATTRIBUTE11 = 'NEW'
126: and MSD.ATTRIBUTE8 = 'ONHAND'
127: and not exists
128: ( select 'exists'
129: from MSC_ST_DEMANDS,
130: hz_parties,
131: msc_system_items msi
132: where msi.organization_id = hp.party_id
133: and hp.party_name = MSD.ATTRIBUTE1

Line 167: MSC_ST_DEMANDS MSD,

163: l_user_id,
164: SYSDATE,
165: l_user_id
166: from hz_parties hz,
167: MSC_ST_DEMANDS MSD,
168: msc_items mi
169: where MSD.ATTRIBUTE3 = mi.item_name
170: and MSD.ATTRIBUTE11 = 'NEW'
171: and MSD.ATTRIBUTE8 = 'ONHAND'

Line 175: UPDATE MSC_ST_DEMANDS

171: and MSD.ATTRIBUTE8 = 'ONHAND'
172: and hz.party_name = MSD.ATTRIBUTE1
173: and hz.party_type = 'ORGANIZATION';
174:
175: UPDATE MSC_ST_DEMANDS
176: SET ATTRIBUTE11 = 'IMPORTED'
177: where ATTRIBUTE11 = 'NEW'
178: and ATTRIBUTE8 = 'ONHAND';
179: