APPS.CSI_RMA_FULFILL_PUB dependencies on CSI_ITEM_INSTANCES

Line 961: FROM csi_item_instances_h cih, csi_transactions ct2

957: SELECT ct.TRANSACTION_TYPE_ID
958: INTO l_last_txn_type_id
959: FROM csi_transactions ct
960: WHERE ct.TRANSACTION_ID = (SELECT Max(ct2.TRANSACTION_ID)
961: FROM csi_item_instances_h cih, csi_transactions ct2
962: WHERE cih.transaction_id = ct2.transaction_id
963: AND cih.instance_id = l_instance_rec.instance_id
964: AND ct2.transaction_type_id = 53
965: AND ct2.source_header_ref_id = p_rma_line_rec.header_id);

Line 1158: FROM csi_item_instances

1154: l_u_instance_rec.quantity := ABS(l_txn_line_dtl_rec.quantity);
1155: Begin
1156: SELECT object_version_number
1157: INTO l_u_instance_rec.object_version_number
1158: FROM csi_item_instances
1159: WHERE instance_id = l_instance_rec.instance_id;
1160: Exception when others then
1161: debug('Fetch instance details failed ...');
1162: fnd_message.set_name('FND','FND_GENERIC_MESSAGE');

Line 1442: from CSI_ITEM_INSTANCES

1438: l_p_instances_tbl(J).config_inst_item_id,
1439: l_p_instances_tbl(J).config_inst_rev_num,
1440: l_p_instances_tbl(J).instance_usage_code,
1441: l_p_instances_tbl(J).active_end_date
1442: from CSI_ITEM_INSTANCES
1443: where instance_id = l_p_instances_tbl(J).instance_id;
1444: --
1445: IF l_locked = TRUE THEN
1446: -- Instance is in Locked Status