APPS.MSC_IMPORT_FORECAST dependencies on MSC_ST_DEMANDS

Line 12: update msc_st_demands

8: IS
9: l_user_id number := fnd_global.user_id;
10: BEGIN
11: -- Validate Seller Code
12: update msc_st_demands
13: set ATTRIBUTE11 = 'ERROR',
14: ATTRIBUTE15 = 'Invalid Seller Code'
15: where not exists (select 'exists'
16: from HZ_PARTIES HP,

Line 17: MSC_ST_DEMANDS MSD

13: set ATTRIBUTE11 = 'ERROR',
14: ATTRIBUTE15 = 'Invalid Seller Code'
15: where not exists (select 'exists'
16: from HZ_PARTIES HP,
17: MSC_ST_DEMANDS MSD
18: where HP.PARTY_NAME = MSD.ATTRIBUTE1
19: and HP.PARTY_TYPE = 'ORGANIZATION')
20: and ATTRIBUTE11 = 'NEW'
21: and ATTRIBUTE8 in ('FORECAST');

Line 24: update msc_st_demands

20: and ATTRIBUTE11 = 'NEW'
21: and ATTRIBUTE8 in ('FORECAST');
22:
23: -- Validate Buyer Code
24: update msc_st_demands
25: set ATTRIBUTE11 = 'ERROR',
26: ATTRIBUTE15 = 'Invalid Buyer Code'
27: where not exists ( select 'exists'
28: from HZ_PARTIES HP,

Line 29: MSC_ST_DEMANDS MSD

25: set ATTRIBUTE11 = 'ERROR',
26: ATTRIBUTE15 = 'Invalid Buyer Code'
27: where not exists ( select 'exists'
28: from HZ_PARTIES HP,
29: MSC_ST_DEMANDS MSD
30: where HP.PARTY_NAME = MSD.ATTRIBUTE2
31: and HP.PARTY_TYPE = 'ORGANIZATION')
32: and ATTRIBUTE11 = 'NEW'
33: and ATTRIBUTE8 in ('FORECAST');

Line 36: update msc_st_demands

32: and ATTRIBUTE11 = 'NEW'
33: and ATTRIBUTE8 in ('FORECAST');
34:
35: -- Validate Quantity
36: update msc_st_demands
37: set ATTRIBUTE11 = 'ERROR',
38: ATTRIBUTE15 = 'Invalid Forecast Quantity'
39: where ATTRIBUTE11 = 'NEW'
40: and ATTRIBUTE8 = 'FORECAST'

Line 57: from msc_st_demands MSD

53: l_user_id,
54: SYSDATE,
55: l_user_id
56: from (select distinct MSD.ATTRIBUTE3
57: from msc_st_demands MSD
58: where MSD.ATTRIBUTE11 = 'NEW'
59: and MSD.ATTRIBUTE8 = 'FORECAST'
60: and not exists (select 'exists'
61: from msc_items item

Line 106: from msc_st_demands MSD,

102: MSD.ATTRIBUTE9,
103: MSD.ATTRIBUTE10,
104: hp.party_id,
105: mi.inventory_item_id
106: from msc_st_demands MSD,
107: hz_parties hp,
108: msc_items mi
109: where mi.item_name = MSD.ATTRIBUTE3
110: and MSD.ATTRIBUTE1 = hp.party_name

Line 116: from msc_st_demands,

112: and MSD.ATTRIBUTE11 = 'NEW'
113: and MSD.ATTRIBUTE8 = 'FORECAST'
114: and not exists
115: ( select 'exists'
116: from msc_st_demands,
117: hz_parties,
118: msc_system_items msi
119: where msi.organization_id = hp.party_id
120: and hp.party_name = MSD.ATTRIBUTE1

Line 166: from msc_st_demands MSD,

162: MSD.ATTRIBUTE9,
163: MSD.ATTRIBUTE10,
164: hp.party_id,
165: mi.inventory_item_id
166: from msc_st_demands MSD,
167: hz_parties hp,
168: msc_items mi
169: where mi.item_name = MSD.ATTRIBUTE3
170: and MSD.ATTRIBUTE2 = hp.party_name

Line 175: from msc_st_demands,

171: and hp.party_type = 'ORGANIZATION'
172: and MSD.ATTRIBUTE11 = 'NEW'
173: and MSD.ATTRIBUTE8 = 'FORECAST'
174: and not exists ( select 'exists'
175: from msc_st_demands,
176: hz_parties,
177: msc_system_items msi
178: where msi.organization_id = hp.party_id
179: and hp.party_name = MSD.ATTRIBUTE2

Line 218: msc_st_demands MSD

214: '-1'
215: from hz_parties seller,
216: hz_parties buyer,
217: msc_items mi,
218: msc_st_demands MSD
219: where seller.party_name = msd.attribute1
220: and seller.party_type = 'ORGANIZATION'
221: and buyer.party_name = msd.attribute2
222: and buyer.party_type = 'ORGANIZATION'

Line 227: UPDATE msc_st_demands

223: and MSD.ATTRIBUTE3 = mi.item_name
224: and MSD.ATTRIBUTE11 = 'NEW'
225: and MSD.ATTRIBUTE8 = 'FORECAST';
226:
227: UPDATE msc_st_demands
228: SET ATTRIBUTE11 = 'IMPORTED'
229: where ATTRIBUTE11 = 'NEW'
230: and ATTRIBUTE8 = 'FORECAST';
231: