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.SR_UWQ_INTEG dependencies on CSI_ITEM_INSTANCES

Line 1173: from csi_item_instances item, hz_parties hzp

1169: -- be passed as parameter.
1170: cursor tag_cursor is
1171: select item.instance_id, item.owner_party_id,
1172: hzp.party_type
1173: from csi_item_instances item, hz_parties hzp
1174: where item.external_reference = p_parameter_value
1175: and hzp.party_id = item.owner_party_id;
1176:
1177: -- Validate the Serial Number

Line 1181: from csi_item_instances item, hz_parties hzp

1177: -- Validate the Serial Number
1178: cursor serial_cursor is
1179: select item.instance_id, item.owner_party_id,
1180: hzp.party_type
1181: from csi_item_instances item, hz_parties hzp
1182: where item.serial_number = p_parameter_value
1183: and hzp.party_id = item.owner_party_id;
1184:
1185: -- Validate the Contract number.