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.AHL_PRD_SERN_CHANGE_PVT dependencies on CSI_IEA_VALUES

Line 93: FROM csi_i_extended_attribs attb, csi_iea_values iea

89: CURSOR csi_i_iea_csr(p_attribute_code IN VARCHAR2,
90: p_csi_instance_id IN NUMBER) IS
91:
92: SELECT iea.attribute_value, iea.attribute_value_id, iea.object_version_number
93: FROM csi_i_extended_attribs attb, csi_iea_values iea
94: WHERE attb.attribute_id = iea.attribute_id
95: AND attb.attribute_code = p_attribute_code
96: AND iea.instance_id = p_csi_instance_id
97: AND trunc(sysdate) >= trunc(nvl(iea.active_start_date, sysdate))

Line 101: l_attribute_value csi_iea_values.attribute_value%TYPE;

97: AND trunc(sysdate) >= trunc(nvl(iea.active_start_date, sysdate))
98: AND trunc(sysdate) < trunc(nvl(iea.active_end_date, sysdate+1));
99:
100: l_return_val BOOLEAN DEFAULT TRUE;
101: l_attribute_value csi_iea_values.attribute_value%TYPE;
102: l_attribute_value_id NUMBER;
103: l_object_version_number NUMBER;
104:
105: BEGIN

Line 228: FROM csi_item_instances csi,csi_iea_values cii

224: -- Changes for ER # 5676360 start
225: Cursor Csi_Iea_Value_Cur(c_instance_id IN NUMBER)
226: IS
227: SELECT cii.attribute_value attribute_value
228: FROM csi_item_instances csi,csi_iea_values cii
229: WHERE csi.instance_id = cii.instance_id
230: AND csi.instance_id = c_instance_id
231: AND cii.rowid in ( select max(rowid) from csi_iea_values
232: where instance_id = csi.instance_id);

Line 231: AND cii.rowid in ( select max(rowid) from csi_iea_values

227: SELECT cii.attribute_value attribute_value
228: FROM csi_item_instances csi,csi_iea_values cii
229: WHERE csi.instance_id = cii.instance_id
230: AND csi.instance_id = c_instance_id
231: AND cii.rowid in ( select max(rowid) from csi_iea_values
232: where instance_id = csi.instance_id);
233:
234: Cursor Csi_Item_Inst_Cur(c_instance_id IN NUMBER)
235: IS

Line 237: FROM csi_item_instances csi,csi_iea_values cii

233:
234: Cursor Csi_Item_Inst_Cur(c_instance_id IN NUMBER)
235: IS
236: SELECT cii.attribute_value attribute_value
237: FROM csi_item_instances csi,csi_iea_values cii
238: WHERE csi.instance_id = cii.instance_id(+)
239: AND csi.instance_id = c_instance_id;
240: -- Changes for ER # 5676360 end
241:

Line 274: -- Check if record doesn't exist in csi iea values

270:
271: OPEN Csi_Iea_Value_Cur(p_instance_id);
272: FETCH Csi_Iea_Value_Cur INTO l_attribute_code;
273: CLOSE Csi_Iea_Value_Cur;
274: -- Check if record doesn't exist in csi iea values
275: IF l_attribute_code IS NULL THEN
276: OPEN Csi_Item_Inst_Cur(p_instance_id);
277: FETCH Csi_Item_Inst_Cur INTO l_attribute_code;
278: CLOSE Csi_Item_Inst_Cur;

Line 297: FROM csi_item_instances csi,csi_iea_values cii

293:
294: Cursor Csi_Iea_Value_Cur(c_instance_id IN NUMBER)
295: IS
296: SELECT decode(mfg_Serial_number_flag, 'N',cii.attribute_value,NULL,cii.attribute_value,'INVENTORY') attribute_value
297: FROM csi_item_instances csi,csi_iea_values cii
298: WHERE csi.instance_id = cii.instance_id
299: AND csi.instance_id = c_instance_id
300: AND cii.rowid in ( select max(rowid) from csi_iea_values
301: where instance_id = csi.instance_id);

Line 300: AND cii.rowid in ( select max(rowid) from csi_iea_values

296: SELECT decode(mfg_Serial_number_flag, 'N',cii.attribute_value,NULL,cii.attribute_value,'INVENTORY') attribute_value
297: FROM csi_item_instances csi,csi_iea_values cii
298: WHERE csi.instance_id = cii.instance_id
299: AND csi.instance_id = c_instance_id
300: AND cii.rowid in ( select max(rowid) from csi_iea_values
301: where instance_id = csi.instance_id);
302:
303: Cursor Csi_Item_Inst_Cur(c_instance_id IN NUMBER)
304: IS

Line 306: FROM csi_item_instances csi,csi_iea_values cii

302:
303: Cursor Csi_Item_Inst_Cur(c_instance_id IN NUMBER)
304: IS
305: SELECT decode(mfg_Serial_number_flag, 'N',cii.attribute_value,NULL,cii.attribute_value,'INVENTORY') attribute_value
306: FROM csi_item_instances csi,csi_iea_values cii
307: WHERE csi.instance_id = cii.instance_id(+)
308: AND csi.instance_id = c_instance_id;
309:
310: Cursor Serial_Tag_Mean_Cur(c_lookup_code IN VARCHAR2)

Line 330: -- Check if record doesn't exist in csi iea values

326: --
327: OPEN Csi_Iea_Value_Cur(p_instance_id);
328: FETCH Csi_Iea_Value_Cur INTO l_attribute_code;
329: CLOSE Csi_Iea_Value_Cur;
330: -- Check if record doesn't exist in csi iea values
331: IF l_attribute_code IS NULL THEN
332: OPEN Csi_Item_Inst_Cur(p_instance_id);
333: FETCH Csi_Item_Inst_Cur INTO l_attribute_code;
334: CLOSE Csi_Item_Inst_Cur;

Line 520: l_attribute_value csi_iea_values.attribute_value%TYPE;

516: l_item_instance_id NUMBER;
517: l_return_val BOOLEAN;
518: l_attribute_value_id NUMBER;
519: l_object_version_number NUMBER;
520: l_attribute_value csi_iea_values.attribute_value%TYPE;
521: l_attribute_id NUMBER;
522: l_idx NUMBER := 0;
523: l_serial_tag_code csi_iea_values.attribute_value%TYPE;
524: l_serial_tag_rec_found VARCHAR2(1) DEFAULT 'Y';

Line 523: l_serial_tag_code csi_iea_values.attribute_value%TYPE;

519: l_object_version_number NUMBER;
520: l_attribute_value csi_iea_values.attribute_value%TYPE;
521: l_attribute_id NUMBER;
522: l_idx NUMBER := 0;
523: l_serial_tag_code csi_iea_values.attribute_value%TYPE;
524: l_serial_tag_rec_found VARCHAR2(1) DEFAULT 'Y';
525: l_transaction_type_id NUMBER;
526: --Adithya added variables as part of fix for Bug# 6683990
527: l_matches_flag VARCHAR2(1);