APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on CSI_ITEM_INSTANCES

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 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 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 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 428: -- Get the current record from csi item instances

424: )
425: AND trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
426: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1));
427:
428: -- Get the current record from csi item instances
429: --Adithya added location_type_code Bug# 6683990
430: CURSOR c_instance_details (c_instance_id IN NUMBER)
431: IS
432: SELECT

Line 441: csi_item_instances

437: serial_number,
438: wip_job_id,
439: location_type_code
440: FROM
441: csi_item_instances
442: WHERE
443: instance_id = c_instance_id;
444:
445: CURSOR mtl_system_items_csr(c_Inventory_id IN NUMBER,

Line 495: FROM CSI_ITEM_INSTANCES CSI,

491: MTL.CONCATENATED_SEGMENTS OLD_ITEM_NUM,
492: AHL_PRD_SERN_CHANGE_PVT.GET_SERIALTAG_CODE (CSI.INSTANCE_ID) OLD_SER_TAG_CODE,
493: CSI.INVENTORY_REVISION OLD_INV_REV,
494: CSI.LOT_NUMBER OLD_LOT_NUM
495: FROM CSI_ITEM_INSTANCES CSI,
496: MTL_SYSTEM_ITEMS_KFV MTL
497: WHERE CSI.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
498: AND CSI.LAST_VLD_ORGANIZATION_ID = MTL.ORGANIZATION_ID
499: AND CSI.INSTANCE_ID = C_INSTANCE_ID;