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

Line 39: from HZ_PARTIES HP,

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,
40: MSC_ST_DEMANDS MSD
41: where HP.PARTY_NAME = MSD.ATTRIBUTE1
42: and HP.PARTY_TYPE = 'ORGANIZATION')
43: and ATTRIBUTE11 = 'NEW'

Line 120: hz_parties hp,

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

Line 130: hz_parties,

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

Line 166: from hz_parties hz,

162: SYSDATE,
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'