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_IMPORT_FORECAST dependencies on HZ_PARTIES

Line 16: from HZ_PARTIES HP,

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,
17: MSC_ST_DEMANDS MSD
18: where HP.PARTY_NAME = MSD.ATTRIBUTE1
19: and HP.PARTY_TYPE = 'ORGANIZATION')
20: and ATTRIBUTE11 = 'NEW'

Line 28: from HZ_PARTIES HP,

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,
29: MSC_ST_DEMANDS MSD
30: where HP.PARTY_NAME = MSD.ATTRIBUTE2
31: and HP.PARTY_TYPE = 'ORGANIZATION')
32: and ATTRIBUTE11 = 'NEW'

Line 107: hz_parties hp,

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
111: and hp.party_type = 'ORGANIZATION'

Line 117: hz_parties,

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
121: and hp.party_type = 'ORGANIZATION'

Line 167: hz_parties hp,

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
171: and hp.party_type = 'ORGANIZATION'

Line 176: hz_parties,

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
180: and hp.party_type = 'ORGANIZATION'

Line 215: from hz_parties seller,

211: SYSDATE,
212: '-1',
213: SYSDATE,
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

Line 216: hz_parties buyer,

212: '-1',
213: SYSDATE,
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'