APPS.CSI_DEBUG_PKG dependencies on CSI_ITEM_INSTANCES

Line 1230: FROM csi_item_instances

1226: instance_usage_code
1227: INTO l_mut_tbl(l_mut_ind).instance_id ,
1228: l_mut_tbl(l_mut_ind).location_type_code,
1229: l_mut_tbl(l_mut_ind).instance_usage_code
1230: FROM csi_item_instances
1231: WHERE inventory_item_id = srl_rec.item_id
1232: AND serial_number = srl_rec.serial_number;
1233:
1234: IF p_error_flag = 'Y' THEN

Line 1739: FROM csi_item_instances

1735: SELECT instance_id,
1736: instance_number
1737: INTO l_instance_id,
1738: l_instance_number
1739: FROM csi_item_instances
1740: WHERE inventory_item_id = p_item_id
1741: AND serial_number = p_serial_number;
1742: IF p_standalone_mode = 'Y' THEN
1743: cache_instance_id(l_instance_id);

Line 2693: FROM csi_item_instances

2689: instance_usage_code,
2690: last_oe_order_line_id,
2691: last_vld_organization_id,
2692: active_end_date
2693: FROM csi_item_instances
2694: WHERE instance_id = p_inst_id;
2695:
2696: CURSOR comp_cur(p_inst_id in number) IS
2697: SELECT iir.relationship_id,

Line 2706: csi_item_instances ii

2702: ii.location_type_code,
2703: ii.instance_usage_code,
2704: ii.active_end_date instance_end_date
2705: FROM csi_ii_relationships iir,
2706: csi_item_instances ii
2707: WHERE iir.object_id = p_inst_id
2708: AND ii.instance_id = iir.subject_id;
2709:
2710: CURSOR txn_cur(p_inst_id IN number) IS

Line 2717: FROM csi_item_instances_h ciih,

2713: to_char(ct.transaction_date, 'mm/dd/yy hh:mi:ss') transaction_date,
2714: to_char(ct.source_transaction_date, 'mm/dd/yy hh:mi:ss') source_transaction_date,
2715: ctt.source_transaction_type,
2716: ct.inv_material_transaction_id
2717: FROM csi_item_instances_h ciih,
2718: csi_transactions ct,
2719: csi_txn_types ctt
2720: WHERE ciih.instance_id = p_inst_id
2721: AND ct.transaction_id = ciih.transaction_id