APPS.CSE_DEPLOYMENT_GRP dependencies on CSI_ITEM_INSTANCES

Line 142: FROM csi_item_instances

138: l_accounting_class_code,
139: l_quantity,
140: l_last_vld_organization_id,
141: l_object_version_number
142: FROM csi_item_instances
143: WHERE instance_id = p_instance_id;
144:
145: debug(' instance_usage_code : '||l_instance_usage_code);
146: debug(' acct_class_code : '||l_accounting_class_code);

Line 233: FROM csi_item_instances

229:
230:
231: SELECT object_version_number
232: INTO l_u_instance_rec.object_version_number
233: FROM csi_item_instances
234: WHERE instance_id = l_u_instance_rec.instance_id;
235:
236: l_u_instance_rec.active_end_date := sysdate;
237: l_u_instance_rec.instance_usage_code := 'OUT_OF_SERVICE';

Line 588: FROM csi_item_instances

584: l_location_type_code,
585: l_location_id,
586: l_instance_usage_code,
587: l_operational_status_code
588: FROM csi_item_instances
589: WHERE instance_id = p_instance_tbl(si_ind).instance_id;
590:
591: l_t_inst_tbl(1).ib_txn_segment_flag := 'S';
592: l_t_inst_tbl(1).instance_id := p_instance_tbl(si_ind).instance_id ;