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 1229: FROM csi_item_instances

1225: l_location_type_code,
1226: l_location_id,
1227: l_instance_usage_code,
1228: l_operational_status_code
1229: FROM csi_item_instances
1230: WHERE instance_id = p_instance_tbl(si_ind).instance_id;
1231:
1232: l_t_inst_tbl(1).ib_txn_segment_flag := 'S';
1233: l_t_inst_tbl(1).instance_id := p_instance_tbl(si_ind).instance_id ;

Line 1518: from csi_item_instances where INSTANCE_ID = l_trf_pa_attr_rec.instance_id;

1514: debug('INSTANCE_ID is ' || p_instance_tbl(si_ind).INSTANCE_ID);
1515:
1516: l_trf_pa_attr_rec.instance_id := p_instance_tbl(si_ind).INSTANCE_ID;
1517: select INV_MASTER_ORGANIZATION_ID into l_trf_pa_attr_rec.inv_master_org_id
1518: from csi_item_instances where INSTANCE_ID = l_trf_pa_attr_rec.instance_id;
1519:
1520: l_trf_pa_attr_rec.serial_number := p_instance_tbl(si_ind).SERIAL_NUMBER;
1521: l_trf_pa_attr_rec.item_id := p_instance_tbl(si_ind).INVENTORY_ITEM_ID;
1522: l_trf_pa_attr_rec.transaction_id := l_txn_rec.TRANSACTION_ID;