APPS.CSI_T_TXN_LINE_DTLS_PVT dependencies on CSI_ITEM_INSTANCES

Line 555: From csi_item_instances

551: Begin
552: Select serial_number, instance_id, lot_number
553: Into p_txn_line_dtl_rec.serial_number, p_txn_line_dtl_rec.instance_id,
554: p_txn_line_dtl_rec.lot_number
555: From csi_item_instances
556: Where config_inst_hdr_id = p_txn_line_dtl_rec.config_inst_hdr_id
557: AND config_inst_item_id = p_txn_line_dtl_rec.config_inst_item_id;
558: --AND config_inst_rev_num = p_txn_line_dtl_rec.config_inst_baseline_rev_num;
559: Exception when others then

Line 571: From csi_item_instances

567: Begin
568: Select serial_number, instance_id, lot_number
569: Into p_txn_line_dtl_rec.serial_number, p_txn_line_dtl_rec.instance_id,
570: p_txn_line_dtl_rec.lot_number
571: From csi_item_instances
572: Where inventory_item_id = p_txn_line_dtl_rec.inventory_item_id
573: and serial_number = p_txn_line_dtl_rec.serial_number;
574: Exception when others then
575: null;-- do nothing. This is just to sync instance data on the tld rec...

Line 583: From csi_item_instances

579: Begin
580: Select serial_number, instance_id, lot_number
581: Into p_txn_line_dtl_rec.serial_number, p_txn_line_dtl_rec.instance_id,
582: p_txn_line_dtl_rec.lot_number
583: From csi_item_instances
584: Where instance_id = p_txn_line_dtl_rec.instance_id;
585: Exception when others then
586: null;-- do nothing. This should not arise though.
587: End;

Line 2056: From csi_item_instances

2052: Begin
2053: Select serial_number, instance_id, lot_number
2054: Into l_td_rec.serial_number, l_td_rec.instance_id,
2055: l_td_rec.lot_number
2056: From csi_item_instances
2057: Where inventory_item_id = l_td_rec.inventory_item_id
2058: and serial_number = l_td_rec.serial_number;
2059: Exception when others then
2060: null;-- do nothing. This is just to sync instance data on the tld rec...

Line 2069: From csi_item_instances

2065: Begin
2066: Select serial_number, instance_id, lot_number
2067: Into l_td_rec.serial_number, l_td_rec.instance_id,
2068: l_td_rec.lot_number
2069: From csi_item_instances
2070: Where instance_id = l_td_rec.instance_id;
2071: Exception when others then
2072: null;-- do nothing. This should not arise though.
2073: End;